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

       

      • userm2300's avatar
        userm2300
        Copper Contributor
        Dec 22, 2020

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

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

      userm2300 

      It gives me 3000 (rounded).

       

Resources