• 412K Members
• 4,904 Online
• 468K 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)

# Re: Excel Formulas adding %

That worked. Thank you.

# Re: Excel Formulas adding %

You’re welcome.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies