Forum Discussion
Solved
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 f...
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")
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