close
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 quot;zeroquot; receiving /div as result.
using formula =(b2-a2)/abs(a2)
Thx in advance for your help.
If I understand you correctly
if(a2gt;0,(b2-a2)/a2,0) format at percentage
If it is percentage change from base year
if($a2gt;0,(b2-$a2)/$a2,0) format at percentage
Regards
Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=513704
全站熱搜
留言列表
