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 Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History