Jan 25, 2019 · One Excel function that I use quite a bit in my formulas is the IF function. The IF function is used to test a logical condition and produce two different results depending on whether the logical condition returns TRUE or FALSE. If you want to check if a cell meets one of multiple conditions, you can combine the IF function and OR function in Excel. The basic form of OR function in Excel is =OR (Logical 1, Logical 2, Logical 3, …, etc.) In our example, we want to find out the unordinary sale volumes which are bigger than 180 or less than 20.