ICT oxford school Azuero

  If The IF function is one of the most used functions in Excel . This page contains many easy to follow IF examples. Simple If Examples The IF function checks whether a condition is met, and returns one value if true and another value if false. 1a. For example, take a look at the IF function in cell B2 below. Explanation: if the price is greater than 500, the IF function returns High, else it returns Low. 1b. The following IF function produces the exact same result. Note: you can use the following comparison operators : = (equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to) and <> (not equal to). 2. Always enclose text in double quotation marks. And/Or Criteria Use the IF function in combinatio...

If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. 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.  And The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false. 1. For example, take a look at the AND function in cell D2 below. Explanation: 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. Or The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false. 1. For example, take a look at the OR function in cell D2 below. Explanation: the OR function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE.  Not The NOT function changes TRUE to FALSE, and FA...