Hello,
Need help to calculate the difference between two numbers as a percentage.
I have an excel file with data (Budget08 (by months), Actual07(by months))
Here the Formula I have to calculate the difference as a percentage
=IF(G2=0,"",IF(I2=0,1,((G2-I2)/I2)))
And I have problems, because it show
the incorrect numbers such as - 496.9%
PLEASE HELP....
THANK YOU
This is an exanple:
G I J
-------------------------------------------
JanBud08 JanAct07 Cng %
-------------------------------------------
7 $0 $8,117
8 $0 $0
9 $85,000 $14,240 496.9%
10 $6,500 $5,792 12.2%
11 $3,500 $0 100.0%