• 468K Members
• 10.1K Online
• 566K Conversations

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

# 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)

# Re: Excel Formulas adding %

That worked. Thank you.

# Re: Excel Formulas adding %

You’re welcome.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies