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.

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

Super! I saw it clearly with the second formula. Thanks very much.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History