Forum Discussion
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!
- DeletedOct 19, 2021Hey,
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
- DeletedHey,
something like this?
=IF(F1=45;1,39;IF(F1=90;2,28;IF(F1=135;3,18;IF(F1=180;4,07;"undefined"))))- PamReynolds1Copper Contributor
Deleted Yes - except it's telling me that it can only have a maximum of 3 equations, and I need 4.
- DeletedHey,
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)