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
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.
4 Likes
