How do I increase numbers by 10%, 15% and 20%?

R

RMPHELP

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

Roger Govier

With 10% in B1, 15% in C1 and 20% in D1
Enter your value 50,000 in A2
In cell B2 =$A2*(1+B$1)
copy across through C2:D2
copy B2:D2 down as far as you wish
Now any values entered in column A will show the corresponding uplifts under
the various % headings
 
R

RagDyer

=A1*1.1
=A1*1.15
=A1*1.2

Is this what you're looking for?
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
S

Steve Yandl

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
 
T

Teribeary

THANKS!!!!!!!!!!!! XD

Roger Govier said:
With 10% in B1, 15% in C1 and 20% in D1
Enter your value 50,000 in A2
In cell B2 =$A2*(1+B$1)
copy across through C2:D2
copy B2:D2 down as far as you wish
Now any values entered in column A will show the corresponding uplifts under
the various % headings
Click to expand...
 
S

star2q

How about an entire row and hide the formula???

Steve Yandl said:
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
Click to expand...
 
D

Dianne

How about an entire row and hide the formula???


I would place 10%(A1), 15%(B1), 20%(C1) or any cells you choose.
A2 55000

B2 =A2+$A$1*A2

C2 =A2+$B$2*A2

D2 =A2+$C$1*A2

select b2 thru D2 and drag the lower right corner down the whol
column. To hide the formula, select the columns with formulas, forma
cell, protection marked hidden and then protect the sheet. You will nee
to unprotect the sheet to make changes unless you unlock cells that d
not contain the formulas.
 
Top