You can combine the IF function with other logical functions such as AND, OR, etc. Let's explore this further. AND function. The IF function can be combined with the AND function to allow you to test for multiple conditions. When using the AND function, all conditions within the AND function must be TRUE for the condition to be met.
Water Quality and Herbivory Interactively Drive Coral-Reef Recovery Patterns in American Samoa. PubMed Central. Houk, Peter; Musburger, Craig; Wiles, Phil. 2010-01-01. Background Compared with a wealth of information regarding coral-reef recovery patterns following major disturbances, less insight exists to explain the cause(s) of spatial variation in the recovery process.