Using "and" in If(

Question

This is probably super elementary, but can someone help me make this work - please? Formula is in a Numeric field.
------------------------------Denis Rochat------------------------------

markshnier__you · Answer

Its simpler syntax ...
just one IF

IF(
[ship density]&lt;1, 400,
[ship density]&lt;2, 300,
ship density], &lt;4, 250&nbsp; etc
The conditions get evaluated from top to bottom in sequence and will grab the first result which is true. So you don't really need to have each subsequent condition eliminate the previous ones above.

But if you did want the extra "wordiness" just for your own readability or understanding it would look like this

IF(
[ship density]&lt;1, 400,
[ship density]&gt;=1 and [ship density] &lt; 2, 300,
[ship density]&gt;=2 and [ship density] &lt; 4, 250 ... etc ,

&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Using "and" in If(