Archive for OR function
How to filter using OR logic between columns [Formula]
The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow […]
If cell equals value from list
The array formula in cell C3 checks if cell B3 is equal to any of the values in E3:E5, the […]
The formula above in cell D3 performs two different logical tests, if at least one of them is TRUE one […]
The above picture shows OR function examples in column D. If the value in column B is equal to a […]
Question: I have a list that I keep adding rows to. How do i create a border that expands as […]
Here is how to highlight every other row using conditional formatting. Conditional formatting formula: =ISEVEN(ROW())*OR($B3:$D3<>"") Alternative CF formula: =EVEN(ROW())=ROW() This […]