If
The IF formula is used to create conditional logic.
Last updated
The IF formula is used to create conditional logic.
Last updated
The If formula is used to create conditional logic. It allows you to evaluate a condition and return one value if the condition is true and another if it’s false.
Condition: The logical expression that will be evaluated (e.g., ThisItem.Stock = 0).
TrueResult: The result or action if the condition is true.
FalseResult: The result or action if the condition is false.
There is a Product Cost table with the cost and the quantity available for sale.
Requirement:
Based on the number in the Stock column, show the status of product stock in the Availability column.
The condition is: if the quantity in stock is greater to 0, the availability status is "Available". Otherwise, it is "Out of Stock".
Formula:
Result:
If the formula and data are correct, you can see the value of column 'Availability' in where you set to view it in the app.
