How do I increase numbers by 10%, 15% and 20%? in Excel General Questions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
RMPHELP 7/19/2005 4:19 PM PST
  Question
  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.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Roger Govier 7/19/2005 4:30 PM PST
  Answer
  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" <RMPHELP@discussions.microsoft.com> wrote in message
news:B1001063-AE5E-4E82-A189-3781AA9E3F64@microsoft.com...
> 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.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Teribeary 9/30/2009 10:12 AM PST
   
  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" <RMPHELP@discussions.microsoft.com> wrote in message
> news:B1001063-AE5E-4E82-A189-3781AA9E3F64@microsoft.com...
> > 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.
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
RagDyer 7/19/2005 4:34 PM PST
   
  =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" <RMPHELP@discussions.microsoft.com> wrote in message
news:B1001063-AE5E-4E82-A189-3781AA9E3F64@microsoft.com...
> 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.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Steve Yandl 7/19/2005 6:32 PM PST
   
  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" <RMPHELP@discussions.microsoft.com> wrote in message
news:B1001063-AE5E-4E82-A189-3781AA9E3F64@microsoft.com...
> 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.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies