percentages

M

Mich

I need the formula to give me the percentage between 2 numbers - i.e.
increase or decrease of 20%.

Thanks.
 
G

Gareth_Evans (InterCall EMEA)

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
 
G

Gareth_Evans (InterCall EMEA)

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.
 
Top