The cell values are C9=550675.20, C10=10172.47, C11=560854.64. When I enter
the formula "=SUM(C11-C10-C9)" the result is 6.97. When I change the formula
to read "=SUM(C11-C10-C9)/C9" the result becomes 1.26572E-05. JUST CAME UP
WITH THE ANSWER. (Talking about it must help). I increased the number of
decimal places in the format of the cell and the correct value is now being
displayed. Thanks for the reply.
Eric wrote:
Tom,
Could you post the end formula exactly as you typed it? It should work,
based on what you've said. Maybe you've misplaced a bracket or some other
typing error.
Regards,
Eric
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
[quoted text clipped - 3 lines]
the % change from the original amount by adding "/A1" to the formula I get an
error. Am I way off?
|