How to if statement for more than one cell ?

How to if statement for more than one cell ?

What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this...

    =IF(ISDATE([3rd Column]@row), [3rd Column]@row, IF(ISDATE([2nd Column]@row), [2nd Column]@row, IF(ISDATE([1st Column]@row), [1st Column]@row))) + n


    Just replace n with however far out you want to go.

    thinkspi.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try something like this...

    =IF(ISDATE([3rd Column]@row), [3rd Column]@row, IF(ISDATE([2nd Column]@row), [2nd Column]@row, IF(ISDATE([1st Column]@row), [1st Column]@row))) + n


    Just replace n with however far out you want to go.

    thinkspi.com

  • Dear Paul ,


    Thank you for your reply,

    I got an error message (#INVALID COLUMN VALUE)

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    The formula above would need to go into a date type column.

    thinkspi.com

  • It is all date type column

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide a screenshot of the columns and the formula generating the error?

    thinkspi.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    And can you provide a screenshot of the column properties for the column that the formula is in?

    thinkspi.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    That's for Date 2 which is referenced in the formula. What about the column the formula is actually in?

    thinkspi.com

  • I got you


    Now It is working perfectly


    Thank you Paul

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Great! Happy to help. 👍️

    thinkspi.com