Excel formulas, comparing numbers

D

DGunn

comparison of numbers over 4 years for % change.
02 03 04 05:

99 55 74 60
1 0 3 4
392 96 71 71
0 2 5 0

with "zero" receiving /div as result.
using formula =(b2-a2)/abs(a2)

Thx in advance for your help.
 
D

Dav

If I understand you correctly

if(a2>0,(b2-a2)/a2,0) format at percentage

If it is percentage change from base year
if($a2>0,(b2-$a2)/$a2,0) format at percentage

Regards

Dav
 
Top