D
Diane1477
I am not sure how to create the following statement properly:
I have Dates in column R and comments in Column S. I want to create a
formula that returns an X in column A if either of the following conditions
are true:
1. If the date in column R is over 2 years from today's date, or
2. If there are notes in column S
I am using the formula :
=IF(OR(R2<TODAY()-730,S2<>""),"X","")
But the above formula is returning an X in column A if column R is blank.
In cases where column R is blank, column A should blank rather than returning
an X.
Any ideas how to get this to work correctly??? Please help...
I have Dates in column R and comments in Column S. I want to create a
formula that returns an X in column A if either of the following conditions
are true:
1. If the date in column R is over 2 years from today's date, or
2. If there are notes in column S
I am using the formula :
=IF(OR(R2<TODAY()-730,S2<>""),"X","")
But the above formula is returning an X in column A if column R is blank.
In cases where column R is blank, column A should blank rather than returning
an X.
Any ideas how to get this to work correctly??? Please help...