• 552K Members
• 3,153 Online
• 661K Conversations

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

# Re: Excel Formulas adding %

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

# Re: Excel Formulas adding %

That worked. Thank you.
Highlighted

# Re: Excel Formulas adding %

You’re welcome.
Related Conversations
Excel behaving strangely
Torben165 in Excel on
0 Replies
facing issue to pull data from particular website
NitinJau in Excel on
0 Replies
SumIf
kaatje77 in Excel on
2 Replies
Custom Sort Alphabet Alphabetizing
jonahw218 in Excel on
3 Replies
Round Down to the nearest 5
jshea23 in Excel on
1 Replies
help with formulae
Gavc1 in Excel on
1 Replies