Skip to main content
Question

IF OR Formulas

Forum|alt.badge.img+8
Hello,

Trying to do a formula that looks at if a field says "Delivered" , however sometimes it could be "DELIVERED" the formula I have now will not pick up both. So can I do an IF OR statement. If so, how?

If([Return Tracking Status]= "DELIVERED" and [Order Cancelled]=false and [Updates Needed]=false, "Complete", "Not Complete")

------------------------------
NOEL HODGES
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    try this

    If(Upper([Return Tracking Status])= "DELIVERED" and [Order Cancelled]=false and [Updates Needed]=false, "Complete", "Not Complete")

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