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
-
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.
Answers
-
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.
-
Dear Paul ,
Thank you for your reply,
I got an error message (#INVALID COLUMN VALUE)
-
The formula above would need to go into a date type column.
-
It is all date type column
-
Are you able to provide a screenshot of the columns and the formula generating the error?
-
And can you provide a screenshot of the column properties for the column that the formula is in?
-
That's for Date 2 which is referenced in the formula. What about the column the formula is actually in?
-
I got you
Now It is working perfectly
Thank you Paul
-
Help Article Resources
Categories
Check out the Formula Handbook template!
