Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read

    Function Reference

    Formulas

    Charts

    Conditional Formatting

    Excel Tables

    Pivot Tables

    VBA Knowledge Base

    Macros

    User Defined Functions

    Videos

    Advanced Excel Course



    Most used functions

    COUNTIF function

    INDEX function

    IF function

    SUM function

    SUMIFS function

    SUMPRODUCT function

    VLOOKUP function




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 […]

IF with OR function

The formula above in cell D3 performs two different logical tests, if at least one of them is TRUE one […]

How to use the OR function

The above picture shows OR function examples in column D. If the value in column B is equal to a […]

Dynamic formatting

Question: I have a list that I keep adding rows to. How do i create a border that expands as […]

Highlight every other row

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 […]

      Formula categories

      Count

      Dates

      Extract

      Index and Match

      Logic

      Lookups

      String manipulation

      Sum

      Time

      Vlookup

  • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
    Don“t forget to add my RSS feed and subscribe to new blog articles by email.
  • Sign up for free blog updates

     
  • Search website

sponsored