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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
=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!
==============================================
 
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
 
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...
 
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...
 
Back
Top