Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase percentage formula
In a1 I have an increase amount of 3%
in B1 I have the toal I pay this month. In C1, if I want to show last months amount times the increase how do I write this formula? The only way I can think of is only showing 3% of last months total. By the way I am hoping to keep this format because I want to be able to change the amount in A1. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase percentage formula
in C1 enter =(1+A1)*B1 if C1 is the new pay and B1 is the old pay.
in C1 enter =B1/(1+A1) if C1 is the old pay and B1 is the new pay. Regards, "Jim" wrote: In a1 I have an increase amount of 3% in B1 I have the toal I pay this month. In C1, if I want to show last months amount times the increase how do I write this formula? The only way I can think of is only showing 3% of last months total. By the way I am hoping to keep this format because I want to be able to change the amount in A1. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage increase | New Users to Excel | |||
percentage increase | Excel Discussion (Misc queries) | |||
How can I create a percentage increase formula? | Excel Worksheet Functions | |||
Excel formula that calculates percentage of increase or decrease | Excel Worksheet Functions | |||
Percentage increase | Excel Worksheet Functions |