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

[Guest]

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.

 

[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 C22
copy B22 down as far as you wish
Now any values entered in column A will show the corresponding uplifts under
the various % headings

 

[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!
==============================================

 

[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

 

[Teribeary]

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

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 C22
copy B22 down as far as you wish
Now any values entered in column A will show the corresponding uplifts under
the various % headings

 

[star2q]

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

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