NOELHODGES
2 years agoQrew Cadet
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
------------------------------
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
------------------------------