Forum Discussion

ghalley's avatar
ghalley
Copper Contributor
Jun 12, 2023

categorizing mild medium hot.

Hello, I am trying to create a spreadsheet formula where if the answer on d24 is 1 then mild, if 2 then medium and if 3 then hot. Any suggestions on writing the formula?

 

thanks;

 

Gustavo

Excel on Mac
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jun 12, 2023

    ghalley 

    One option:

     

    =IFS(D24=1, "mild", D24=2, "medium", D24=3, "hot", TRUE, "")

     

    Another one:

     

    =IFERROR(CHOOSE(D24, "mild", "medium", "hot"), "")

     

    And one more: enter the values 1, 2, 3 in a range, for example V1:V3, and mild, medium and hot in the cells to the right, i.e. W1:W3.

     

    =XLOOKUP(D24, $V$1:$V$3, $W$1:$W$3, "")

    or

    =IFERROR(VLOOKUP(D24, $V$1:$W$3, 2, FALSE), "")

     

    =

Resources