Forum Discussion

UserM2235's avatar
UserM2235
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's avatar
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's avatar
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's avatar
    JMB17
    Bronze Contributor
    Dec 22, 2020
    =X*Y*1.0035
    • userm2300's avatar
      userm2300
      Copper Contributor
      Dec 22, 2020

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

      • JMB17's avatar
        JMB17
        Bronze Contributor
        Dec 22, 2020

        userm2300 

         

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

         

Resources