Excel formulas, comparing numbers
 

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.

Excel formulas, comparing numbers
 

If I understand you correctly

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

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=513704