subtracting decimals percentages in excel

[UserM2235]

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

[#2]

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

[#3]

@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

[#4]

=X*Y*1.0035

[#5]

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

[#6]

@userm2300 

It gives me 3000 (rounded).

[#7]

@userm2300 

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

[#8]

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

[#9]

@userm2300 

=15332.92*0.19497503*(1-0.0035)