subtracting decimals percentages in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2007893%22%20slang%3D%22en-US%22%3Esubtracting%20decimals%20percentages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007893%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20formula%20I%E2%80%99m%20trying%20to%20do%20in%20excel%20Buy%20amount%20%E2%80%93%20Fee%20%C3%B7%20Desired%20Price%20%3D%20amount.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIe%2020000%20%E2%80%93%200.35%25%20%C3%B7%2016500%20%3D%201.2078%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20will%20not%20%E2%80%93%200.35%25.%20What%20formula%20do%20I%20need%20to%20use%3F%20The%20formula%20im%20using%20is%20%3DB20-C20%2FD20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2007893%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-2008133%22%20slang%3D%22en-US%22%3ERe%3A%20subtracting%20decimals%20percentages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008133%22%20slang%3D%22en-US%22%3EExcel%20follows%20the%20standard%20order%20of%20operations%20and%20divides%20before%20subtracting.%20So%2C%200.35%25%2F16500%20is%20a%20very%20small%20decimal.%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%2C%20I'm%20guessing%20the%200.35%25%20fee%20is%20based%20on%20the%20buy%20amount%3F%3CBR%20%2F%3E%3CBR%20%2F%3ETry%20this%3A%3CBR%20%2F%3E%3D(B20-B20*C20)%2FD20%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2008598%22%20slang%3D%22en-US%22%3ERe%3A%20subtracting%20decimals%20percentages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008598%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20that%20worked%3C%2FP%3E%3CP%3EWhat%20formula%20would%20I%20need%20for%20X*Y%2B0.35%25%3DZ%3C%2FP%3E%3CP%3EIe%2015%2C332.92%20*%200.19497503%20%2B%200.35%25%20%3D%202%2C999.99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010248%22%20slang%3D%22en-US%22%3ERe%3A%20subtracting%20decimals%20percentages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010248%22%20slang%3D%22en-US%22%3E%3DX*Y*1.0035%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010293%22%20slang%3D%22en-US%22%3ERe%3A%20subtracting%20decimals%20percentages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3BHay%20thanks%20for%20the%20reply%2C%20that%20gives%20me%2030%20instead%20of%203000%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

This is the formula I’m trying to do in excel Buy amount – Fee ÷ Desired Price = amount.

 

Ie 20000 – 0.35% ÷ 16500 = 1.2078

 

But it will not – 0.35%. What formula do I need to use? The formula im using is =B20-C20/D20

8 Replies
Excel follows the standard order of operations and divides before subtracting. So, 0.35%/16500 is a very small decimal.

Also, I'm guessing the 0.35% fee is based on the buy amount?

Try this:
=(B20-B20*C20)/D20

@JMB17 

 

Thanks that worked

What formula would I need for X*Y+0.35%=Z

Ie 15,332.92 * 0.19497503 + 0.35% = 2,999.99

=X*Y*1.0035

@JMB17 Hay thanks for the reply, that gives me 30 instead of 3000?

@userm2300 

It gives me 3000 (rounded).

JMB17_0-1608665554718.png

 

@userm2300 

 

If you added a % sign at the end, then you also have to move the decimal. 

JMB17_0-1608665747011.png

 

@JMB17 i see and what if i want to take away a fee of 0.35%

@userm2300 

 

=15332.92*0.19497503*(1-0.0035)

 

JMB17_0-1608667115655.png