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

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.

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


--
Regards
Roger Govier
"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.

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


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

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.

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

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

"Roger Govier" wrote:

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


--
Regards
Roger Govier
"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.

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.