If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I increase numbers by 10%, 15% and 20%?
How about an entire row and hide the formula???
"Steve Yandl" wrote: It's just a simple multiplication. If the start value is in A1 =A1*1.1 is a 10% increase, =A1*1.15 is a 15% increase. =A1*1.20 is a 20% increase etc. Steve "RMPHELP" wrote in message ... This is probably very simple, but I am trying to write a formula to increase a number by 10%, 15% and 20%. For example, increasing 50000 by 10% with a result of 55000, by 15% = 57500 and 20% = 60000. |
Thread Tools | |
Display Modes | |
|
|