Re: How do I increase numbers by 10%, 15% and 20%?
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 00:28:14 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1001063-AE5E-4E82-A189-3781AA9E3F64@xxxxxxxxxxxxxxxx
> 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.
.
- References:
- How do I increase numbers by 10%, 15% and 20%?
- From: RMPHELP
- How do I increase numbers by 10%, 15% and 20%?
- Prev by Date: How do I increase numbers by 10%, 15% and 20%?
- Next by Date: Re: Decision Tree Template or Plug In
- Previous by thread: How do I increase numbers by 10%, 15% and 20%?
- Next by thread: Re: How do I increase numbers by 10%, 15% and 20%?
- Index(es):
Relevant Pages
|
