Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages
I need the formula to give me the percentage between 2 numbers - i.e.
increase or decrease of 20%. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages | Excel Discussion (Misc queries) | |||
percentages | New Users to Excel | |||
percentages | Excel Discussion (Misc queries) | |||
percentages | Excel Worksheet Functions | |||
percentages | Excel Worksheet Functions |