Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to make formula where the text value is the condition

Topic Labels: Formulas
777 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Fadwa_Majed
4 - Data Explorer
4 - Data Explorer

Hello, I’m having troubles figuring away the proper way to make a formula that will:
"if the status = canceled or replaced, the value of the field should be = quantity-quantity (making it a 0) "
where the status is a single select field,
how can I make this work?
Many thanks in advance

1 Reply 1
JonathanB
8 - Airtable Astronomer
8 - Airtable Astronomer

Have you tried:

IF(OR({Status}="Canceled", {Status}="Replaced"), ({Quantity}-{Quantity}))

?