Home

Excel Formulas adding %

%3CLINGO-SUB%20id%3D%22lingo-sub-756853%22%20slang%3D%22en-US%22%3EExcel%20Formulas%20adding%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756853%22%20slang%3D%22en-US%22%3EGood%20morning%2C%20I'm%20trying%20to%20create%20a%20simple%20formula%20where%20I%20take%20a%20base%20dollar%20amount%20and%20divide%20by%20a%20percentage%20for%20the%20next%20cell.%3CBR%20%2F%3EFor%20instance%3A%20%2410.00%20%C3%B7%20.95%25%3CBR%20%2F%3E%3CBR%20%2F%3EI've%20tried%20to%20use%3CBR%20%2F%3E%3D%2BA1*0.05%20in%20cell%20A2%3CBR%20%2F%3EBut%20it%20is%20only%20giving%20me%20to%20amount%20of%20the%20percentage%20and%20not%20add%20it%20to%20the%20previous%20cell%20for%20a%20total.%3CBR%20%2F%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756877%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20adding%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756877%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3DA1*1.05%3CBR%20%2F%3EIt%E2%80%99s%20better%20if%20you%20enter%200.05%20in%20B1%2C%20then%20use%20this%20formula%20in%20C1%3A%3CBR%20%2F%3E%3DA1*(1%2BB1)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756949%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20adding%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756949%22%20slang%3D%22en-US%22%3EThat%20worked.%20Thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756960%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%20adding%20%25%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756960%22%20slang%3D%22en-US%22%3EYou%E2%80%99re%20welcome.%3C%2FLINGO-BODY%3E
Deeny
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
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.
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
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies