Forum Discussion

BeJackier's avatar
BeJackier
Copper Contributor
Nov 02, 2019
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...
Excel Formula
Excel Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Nov 06, 2019

    BeJackier 

    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")

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Nov 02, 2019

BeJackier 

What happens when you go to the cell with formula and press F2 followed by ENTER?

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 04, 2019

    BeJackier 

    Could you provide a stripped version of your workbook?

     

    • BeJackier's avatar
      BeJackier
      Copper Contributor
      Nov 04, 2019

      Detlef_Lewin 

       

      Not familiar with that term. What is a stripped version?

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Nov 04, 2019

        BeJackier 

        Stripped workbook -> not the complete workbook, just the relevant part and anonymize the data.

Resources