funcion switch

[CJP]

Can someone please tell me what's wrong here?

Switch(Number([IMC]),
<=30,"ok",
<=40,"No",
"62")

Appsheet says "Expression 'Switch(Number([IMC]), <=30,"ok", <=40,"No", "62")' was unable to be parsed: Sequence contains no elements."

Thanks

[WillowMobileSys · Accepted solution]

SWITCH() cannot check a range of values.  It is meant for precise matching only.  If you wish to check value ranges then you will want to use the IFS() function.

https://help.appsheet.com/en/articles/2355961-ifs

[CJP]