Skip to main content
Question

Using "and" in If(

  • July 4, 2023
  • 0 replies
  • 322 views
Forum|alt.badge.img+3

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



------------------------------
Denis Rochat
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • July 4, 2023

    Its simpler syntax ...

    just one IF

    IF(

    [ship density]<1, 400,

    [ship density]<2, 300,

    ship density], <4, 250  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]<1, 400,

    [ship density]>=1 and [ship density] < 2, 300,

    [ship density]>=2 and [ship density] < 4, 250 ... etc ,

     



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement