The OR function in Microsoft Excel 2019

The OR function returns TRUE if any argument is true and returnsFALSE if all the arguments arefalse. In the following example, the student must pass at least onesubject and with at least 60%. We will use the OR function towork this out, as follows:

  1. We have the OR-Function.xlsx workbook open for thisexample.
  2. Click on cell C8 and enter the following formula: =OR(B8>=0.6,B9>=0.6,B10>=0.6).
  3. Press Enter to see the formula result.
  4. Try the OR function on the second set of results—thistime, the arguments return TRUE.

Leave a Comment