 # subtracting decimals percentages in excel

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

# Re: subtracting decimals percentages in excel

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

# Re: subtracting decimals percentages in excel

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

# Re: subtracting decimals percentages in excel

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

# Re: subtracting decimals percentages in excel

It gives me 3000 (rounded). # Re: subtracting decimals percentages in excel

If you added a % sign at the end, then you also have to move the decimal. # Re: subtracting decimals percentages in excel

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

# Re: subtracting decimals percentages in excel

=15332.92*0.19497503*(1-0.0035) 