How to use IF with AND and OR
Download the practice worksheet here: If this OR that Practice.xlsx
This is part of a 3-part series on Excel formulas.
There are two requirements that must be satisfied, and both evaluated inside a single AND statement. The first requirement is at least 5 volunteer hours in each of the 3 categories: A, B, and C. This requirement is tested with a logical statement based on the COUNTIF function:
COUNTIF(C6:E6,">=5")=3
In the range C6:E6, we count numbers greater than or equal to 5.
The second requirement is to have at least 15 volunteer hours total. This requirement is tested with a simple logical expression based on the SUM function:
SUM(C6:E6)>=15)
If both the the logical conditions return TRUE, the AND function will return TRUE. IF either returns FALSE, AND will return false.
Get over 100 Excel Functions you should know in one handy PDF.