change a column value based on a range from another column

[Gardener76]

Whats the best way to change a column value based on a range from another column?

I have BMI Column (number) and the Range column (text).

The Range column (Underweight, Healthy, Overweight, Obese) will populate based on the ranges of the BMI column this range can vary between (18.5 - 40). The ranges are as (< 18.5 = Underweight), (18.5 and 24.9 =Healthy), (25 and 29.9 = Overweight) and (30 and 39.9 = Obese).

I have tried looking through Expressions, unsure which would best suit this and how to construct the formula accordingly. Help much appreciated. 

Thanks in advance.

[Suvrutt_Gurjar · Accepted solution]

Please try using IFS()

something like 

IFS( [BMI]< 18.5, " Underweight",
[BMI]<=24.9, "Healthy",
[BMI]<=29.9, "Overweight",
[BMI]> 29.9 , "Obese" )

IFS() - AppSheet Help

[Gardener76]

Thank you so much, this is exactly what I needed. I can add this to so many other tables now and projects. Magic, thank you once again.