With the IFS function you can have multiple conditions in one statement
A value is returned by IFS only when the previous condition returns TRUE, and the first condition to return TRUE "wins".
When one of the conditions is met (condition_1, condition_2, etc), its corresponding value is returned
will return 300, since the second condition is true
You need to make sure the conditions cover all the possible cases, so for example if you have a number field between 0 and 300, you can have: