video tutorial on how to use microsoft excel

The FALSE value is being replaced by another IF function to make a further test.ġ.

The IF function in Excel can be nested, when you have multiple conditions to meet. If TRUE, the IF function reduces the price by 50%, if FALSE, the IF function reduces the price by 10%. The AND function returns TRUE if Product equals 'Table' and Color equals 'Green' or 'Blue'. For example, take a look at the IF function in cell D2 below.Įxplanation: the AND function above has two arguments separated by a comma (Table, Green or Blue). 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 OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE. 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.

Video tutorial on how to use microsoft excel