Prev: Percentage format
Next: Lookup
From: Mich on 4 Feb 2010 10:01
I need the formula to give me the percentage between 2 numbers - i.e.
increase or decrease of 20%.

Thanks.
From: Gareth_Evans (InterCall EMEA) on 4 Feb 2010 10:17
Hi Mich,

Where A2 contains your number and B2 contains your percentage value:

=A2*(1-B2) Decreases 25 by 25%
=A2*(1+B2) Increases 25 by 25%
=A2*(1+35%) Increases 25 by 35%

Hope this helps,

Best Regards

Gareth
From: Gareth_Evans (InterCall EMEA) on 4 Feb 2010 10:19
Sorry - try this instead, this will give you a value between two numbers:

=(B2-A2)/ABS(A2)

Where A2 and B2 are the cells that contain the two values you want to find
the difference between.

"Mich" wrote:

> I need the formula to give me the percentage between 2 numbers - i.e.
> increase or decrease of 20%.
>
> Thanks.
 | 
Pages: 1
Prev: Percentage format
Next: Lookup