Percentage Formula
Caribbrz schrieb:
This is what I have
In cell D - 484
In Cell E - 526
Now in Cell E I want to display the percentage of increase (or decrease)
The formula I currenty am using is
(D1-E1)/D1
With this I get -9% This can't be correct...becuase it is an increase.
What am I doing wrong?
Lisa
Hi, Lisa,
I think you have to change the positions like
(E1-D1)/(D1*100) -- 8.67...percents increase
|