View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DGunn
 
Posts: n/a
Default 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.