categorizing mild medium hot.

[ghalley]

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

[#2]

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

=