Excel Formulas adding %

Highlighted
New Contributor
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
Highlighted
Try this:
=A1*1.05
It’s better if you enter 0.05 in B1, then use this formula in C1:
=A1*(1+B1)
Highlighted
That worked. Thank you.
Highlighted
You’re welcome.