Excel: OR sign - does the sign exist in Excel?

If you want to make an OR query in a program, you need the appropriate sign for it. You can also make such a query in Excel. However, there are no special characters for this as you find them in other programs. Microsoft, however, offers you a suitable function.

How to use the OR function

If you want to make an OR query in Excel, you do not need a special sign for it. Instead, the spreadsheet program provides a function for this purpose. You can use the OR function to make the same queries as you would with a character.

1. The OR function gives a "TRUE" or a "FALSE" as its output. To output the result of the query, you must write the function in an empty cell.
2. For example, if you enter "=OR(A2>1;A2<100)", then "TRUE" will be output exactly when the value in cell A2 is greater than 1 or less than 100.
3. In addition, you can include the function in a IF function. For example, you can enter the command "=WHEN(OR(A2>1;A2<100);A3; "NOT VALID")" . This means that if the value in cell A2 is greater than 1 or less than 100, then the value "NOT VALID" will be output in cell A3.
4. You can enter any output and make the conditions even more complex. This depends on the information you want to check.