Forum Discussion

Deeny's avatar
Deeny
Copper Contributor
Jul 16, 2019

Excel Formulas adding %

Good morning, I'm trying to create a simple formula where I take a base dollar amount and divide by a percentage for the next cell.
For instance: $10.00 ÷ .95%

I've tried to use
=+A1*0.05 in cell A2
But it is only giving me to amount of the percentage and not add it to the previous cell for a total.
Any help would be greatly appreciated.

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Try this:
    =A1*1.05
    It’s better if you enter 0.05 in B1, then use this formula in C1:
    =A1*(1+B1)