Forum Discussion
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
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), "")
=