Forum Discussion

NOELHODGES's avatar
NOELHODGES
Qrew Cadet
2 years ago

IF OR Formulas

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
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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
    ------------------------------