Hello friends,
My name is Tabrez Ajaz. In this post, we'll see how to work with Conditional Formula like AND and IF-AND.
When you are using conditional formulas you can also use AND's.
- All Conditions with AND need to be TRUE for get True result.
- =AND(unitsInStock > threshold, soldLastYear < 500), returns true if both conditions will true
- =IF(AND(unitInStock > threshold, soldLastYear < 500),"Sale","Full"), it returns Sale if both conditions were true otherwise this will return Full.
Use previously created the list for this demo named: "Products"
Create following columns:
itemsToPutOnSale (Calculated Column) [=AND([unitsInStock] > [threshold], [soldLastYear] < 500)]
=AND(UnitsInStock>threshold,soldLastYear<500)
Output:
Let's see IF-AND together:
create new column name: IF-AND only for test
=IF(AND(UnitsInStock>threshold,soldLastYear<500),"Sale","Full")
Output:
I hope you understand how to use Conditional formula (like, AND and IF-And) with your calculated column for getting required result.