- For example, take a look at the IF function in cell C2 below. Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail. Visit our page about the IF function for many more examples. The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. 1.
For More Information Please Refer:
You May Also Like to Read:
How do you add sales value in Excel?