Forum Discussion
PamReynolds1
Oct 19, 2021Copper Contributor
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...
- 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)
Deleted
Oct 19, 2021Hey,
something like this?
=IF(F1=45;1,39;IF(F1=90;2,28;IF(F1=135;3,18;IF(F1=180;4,07;"undefined"))))
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
Oct 19, 2021Copper Contributor
Deleted Yes - except it's telling me that it can only have a maximum of 3 equations, and I need 4.
- 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)- PamReynolds1Oct 19, 2021Copper ContributorI have O365, so it should be the latest and greatest version.
- DeletedOct 19, 2021Ok, because then you should be able to apply the function, since the limit for nested if statements, as far as I know, is 64.