Forum Discussion
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 ma...
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)
Deleted Yes - except it's telling me that it can only have a maximum of 3 equations, and I need 4.
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)
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)
- I have O365, so it should be the latest and greatest version.
- Ok, because then you should be able to apply the function, since the limit for nested if statements, as far as I know, is 64.
- Thank you!!! I got it to work! After looking more closely I had missed a comma. Ugh. THANKS for the help!!