Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Two condition Formula

532 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Here is my current formula: IF(Store=“A”,(({Price}/100)*10))
This formula gives me the calculation of 10% of the figure in the Price column if the store in the Store column is A.
So far so good.
But how do I add store B to that formula? Say I have store A, B, C, D etc but I only want the formula applied if the store is A or B in the Store column?
Thanks in advance.

2 Replies 2

To run the same calculation for both stores A and B, you can use OR() to look for either one. You can also simplify your calculation:

IF(OR(Store = "A", Store = "B"), {Price} * .1)
4 - Data Explorer
4 - Data Explorer

Thank you so much @Justin_Barrett, it worked! I spent 2 hours on it last night and couldn’t work it out.