Forum Discussion
Problem with IFS Formula
Hi,
I have written the following formula: =IFS(F118>89,"A",F118>79,"B",F118>69,"C",F118>59,"D",TRUE,"F")
The value for F118 is 92 (that cell has the following formula: =AVERAGE(F55,F116)). The formula ONLY returns the value F. I have tried any number of combinations for cell 118 (including doing away with the formula and just putting in a number) and iterations of the formula. Yet it still returns only an F. I cannot figure out where I am missing it and would appreciate some help.
Thanks,
Barry
The value in F118 is a percentage.
Your formula has to be amended:
=IFS(F118>89%,"A",F118>79%,"B",F118>69%,"C",F118>59%,"D",TRUE,"F")
16 Replies
Try IF formula instead of IFS as below
=IF(F118>89%,"A",IF(F118>79%,"B",IF(F118>69%,"C",IF(F118>59%,"D","F")))) BeJackier
I'm not a fan of IFS.
This is what I'd do:
=VLOOKUP(F118,{0,"F";59,"D";69,"C";79,"B";89,"A"},2,1)
- it does not give "F" for less than 59 Patrick2788
That's odd. It works alright for me.
same result
