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