Solved Adding a % to a number aleady in cell and summing to two

October 17, 2012 at 09:11:25
Specs: Windows XP
I'm working on a budget and I would like to add a 5% to an amount (say $125) already in a cell, say A2. A2 has a formula pulling from another sheet and I want to show the result of $125 X 5% + $125.
Thanks.

See More: Adding a % to a number aleady in cell and summing to two

Report •

#1
October 17, 2012 at 12:02:51
✔ Best Answer
=A2*(1.05)

or, if you want to easily test other percentages...

=A2*(1+$B$1) where B1 contains 5%

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 17, 2012 at 13:13:20
Super! I saw it clearly with the second formula. Thanks very much.

Report •
Related Solutions


Ask Question