If TRUE, the IF function returns Pass, if FALSE, the IF function returns Fail.Ģ. For example, take a look at the IF function in cell D2 below.Įxplanation: the AND function returns TRUE if the first score is greater than or equal to 60 and the second score is greater than or equal to 90, else it returns FALSE. Use the IF function in combination with the AND function and the OR function and become an Excel expert.ġ. You can use the IF function to display an empty string if the end value hasn't been entered yet (see row 5).Įxplanation: if the end value is not empty ( means not equal to), the IF function calculates the progress between the start and end value, else it displays an empty string (two double quotes with nothing in between). The formula below calculates the progress between two points in time.ģb. Always enclose text in double quotation marks.ģa. Note: you can use the following comparison operators: = (equal to), > (greater than), = (greater than or equal to), (not equal to).Ģ.

The following IF function produces the exact same result.

Explanation: if the price is greater than 500, the IF function returns High, else it returns Low.ġb.

Excel if and