Construction of the OR function in Excel
- The formula is "=OR(Condition1;Condition2;...)".
- You can install in the OR function, any number of conditions.
- If none of the conditions is met, the program "INCORRECTLY".
- As a condition, you can, for example, not equal to, such as "A1B2;A3>B3, A4>B4;A5>B5;);"Not OK";"OK")" a.
- Excel now returns "OK" if none of the values exceeds the limit. The OR function returns, in the case of "WRONG".
- One of the values exceeds the limit, it will return "Not OK".
OR function in IF install
In the next practical tip we will show you how to make your Excel spreadsheet with conditional formatting in a clear overview.
