You already have the correct formula. You are doing the "accountancy
comparison between the two columns". If you post back with sample data, and
the specific results you want in each situation, then maybe we can come up
with appropriate formulas.

Regards,
Fred

"puiuluipui" wrote in message
...
Hi, i understand your explication. Can you help me with a solution? I need
to
make a comparison. I have two column representing sales value. In first
column i have february and in second column i have march. I need to know
how
much the value of sales increased or decreased(%). How many times the
value
increased or decreased(the sales increased 70.4 times).
Even though the formula is correct, i need a simple way for both
situations(2394 and 34 ; 34 and 2394). I need to know that one product
decreased and another increased sales value.(+ and -)

If i use the first formula in both situations, i will be very confused. I
need another way.
I just want to make a accountancy comparison between two columns.
Can you help me?
Thanks!




"Fred Smith" wrote:

Percentages don't work that way. If your investment portfolio drops 50%
(from $10,000 to $5,000), you need a 100% increase to get back to your
starting position. Similarly, going from 2394 to 34 is a 98% decrease,
but
to get from 34 back up to 2394, you need a 6941% increase. Your original
formulas are correct.

Regards,
Fred

"puiuluipui" wrote in message
...
Hi, i have this two situations:

2394 34 -98,58%
34 2394 6941,18%

This is the formulas i used:
=(B1-A1)/ABS(A1)
=(B2-A2)/ABS(A2)
I need a formula to calculate the percentage of differences between two
numbers even if the first is bigger than the second or the other way
around.

This is how i need the final result to look:
2394 34 -98,58%
34 2394 +98,58%

Can this be done?
Thanks!






.