What are the values? What exactly is your formula? What error do you get?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Tom B via OfficeKB.com" wrote in message
...
I'm using the formula (A2-A1)/A1 to determine the % change between two
cells.
I have an instance where I need to subtract the value of two cells from
the
current cell before determining the % change. I've come up with several
different ways to arrive at the actual changed value (e.g. A3-SUM(A1:A2)
or
SUM(A3-A2-A1) ) which return the correct value but when I try to arrive at
the % change from the original amount by adding "/A1" to the formula I get
an
error. Am I way off?
|