M Mich Feb 4, 2010 #1 I need the formula to give me the percentage between 2 numbers - i.e. increase or decrease of 20%. Thanks.
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) Feb 4, 2010 #2 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
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) Feb 4, 2010 #3 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.
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.
