Forum Discussion

Copper Contributor

Dec 21, 2020

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 ...

Formulas and Functions

JMB17

Bronze Contributor

Dec 21, 2020

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

userm2300
Copper Contributor
Dec 22, 2020
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
- JMB17
  Bronze Contributor
  Dec 22, 2020
  =X*Y*1.0035
  - userm2300
    Copper Contributor
    Dec 22, 2020
    JMB17 Hay thanks for the reply, that gives me 30 instead of 3000?