Forum Discussion

PamReynolds1's avatar
PamReynolds1
Copper Contributor
Oct 19, 2021
Solved

Can you create multiple IF formulas on one cell?

I am trying to create a formula so that when a certain number appears in the cells in Column F that the logic applies the correct PayPal fee in Column G.  The fee is not set percentage, so I can't make it a math formula.  The fee percentage changes the higher the value.  I used the "IF" formula to say that when the cell in Column F is $45 then put $1.39 in the cell in Column G.  BUT - F could also be $90, $135 or $180.  I want the formula to say that if F is $45 then G is $1.39; if F is $90 then G is $2.28; if F is $135 then G would be $3.18 and if F is $180 then G would be $4.07.  I don't know how to give the formula 4 different options of which fee to put into Column G.  Thanks for the assistance! 

  • Deleted's avatar
    Deleted
    Oct 19, 2021
    Hey,
    what version of Excel are you using?
    You could also try:
    =IFS(F1=45;1,39;F1=90;2,28;F1=135;3,18;F1=180;4,07)

6 Replies

  • Hey,

    something like this?
    =IF(F1=45;1,39;IF(F1=90;2,28;IF(F1=135;3,18;IF(F1=180;4,07;"undefined"))))
    • PamReynolds1's avatar
      PamReynolds1
      Copper Contributor

      Deleted Yes - except it's telling me that it can only have a maximum of 3 equations, and I need 4.

      • Deleted's avatar
        Deleted
        Hey,
        what version of Excel are you using?
        You could also try:
        =IFS(F1=45;1,39;F1=90;2,28;F1=135;3,18;F1=180;4,07)

Resources