categorizing mild medium hot.

Copper Contributor

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?





1 Reply


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


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