Forum Discussion
Delta % calculation
Can anybody help me im desperate!! column A1 has a total 1500 column A2 is 0 column A3 is the delta (1500 - 0) column A4 shows the percentage as #DIV/0! cannot remember how this formula works...
A1 would be the current total
A2 the previous total
A3 is the change from the previous value
A4 (the percentage change) is the delta divided by the previous total.
The calculation is correct but for very small or negative prior values A2, it is just not very useful. To suppress the error you could use a formula
= IF( A2>0, A3/A2, "not available" )