Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to make formula where the text value is the condition

Topic Labels: Formulas
222 1
Showing results for 
Search instead for 
Did you mean: 

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

Have you tried:

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