Forum Discussion
Solved
IFS formula in Excel 2016
Hello all! I have created a spreadsheet that contains multiple IFS formulas. They work perfect in Office 365 Excel, Google sheets, etc. However, they seem to return a #NAME in Excel 2016. D...
That would be
=IF(E4>89, 5, IF(E4>69, 4, IF(E4>39, 3, IF(E4>0, 2))))
If E4 will never contain a number <=0, you can shorten it to
=IF(E4>89, 5, IF(E4>69, 4, IF(E4>39, 3, 2)))
Hello HansVogelaar ,
Thank you for the quick reply!
Im not sure I fully understand how to separate them.
I tried: =IF(E4>89, 5), IF(E4>69, 4), IF(E4>39, 3),IF(E4>0, 2) but get a #value return.
Would it be possible to help with this example?
=@IFS(E4>89, 5, E4>69, 4, E4>39, 3, E4>0, 2)
Thanks in advance!
That would be
=IF(E4>89, 5, IF(E4>69, 4, IF(E4>39, 3, IF(E4>0, 2))))
If E4 will never contain a number <=0, you can shorten it to
=IF(E4>89, 5, IF(E4>69, 4, IF(E4>39, 3, 2)))