Forum Discussion

Terrie Grusnis's avatar
Terrie Grusnis
Copper Contributor
Apr 25, 2017
Solved

IFS function with multiple criteria

I'm trying to write an IFS funtion with values returned on three criterias and I'm having a problem with the second criteria. The first criteria is to return a value if the cell has a value less than...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 25, 2017

    Hi Terrie,

     

    Try this

    =IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 25, 2017

Hi Terrie,

 

Try this

=IFS(N12>84,"7+",N12>36,"3-7",N12<=36,"0-3")
  • Terrie Grusnis's avatar
    Terrie Grusnis
    Copper Contributor
    Apr 25, 2017

    Thank you so much, Sergei, that worked!! Much appreciated.

     

    Sincerely,

    Terrie Grusnis