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...

=IF(OR(R2DATE(YEAR(TODAY())+2,MONTH(TODAY()),DAY( TODAY())),S2<""),"X","")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Diane1477" wrote in message
...
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...

=IF(OR(TODAY()<R2-730,S2<""),"X","")

Happy New Year!!
Ryan--


"Diane1477" wrote:

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...

On Dec 31, 9:15*am, Diane1477
wrote:
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.

=if(R2="", "", if(or(R2<today()-730, S2<""), "X", ""))

Or:

=if(or(and(R2<"", R2<today()-730), S2<""), "X", "")

Bob and Ryan thank you very much! They both worked!!

"RyGuy" wrote:

=IF(OR(TODAY()<R2-730,S2<""),"X","")

Happy New Year!!
Ryan--


"Diane1477" wrote:

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...

=IF(OR(ISTEXT(S2),R2TODAY()+730),"X","")

Vaya con Dios,
Chuck, CABGx3



"Diane1477" wrote:

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 thought the formulas suggested worked, but in rows where column R fits the
criteria for an X but Column S is blank, an X is not displaying in Column A.
Any other ideas??

"Diane1477" wrote:

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...

If you set up a test worksheet with ALL of the suggested formulas you will
see differeing degrees of "working" when varying the conditions.........I
believe my suggestion does as you wish with the added benefit of not giving
an "X" if there is only a NUMBER in column S rather than a TEXT comment, in
case that may be of value...........

Vaya con Dios,
Chuck, CABGx3



"Diane1477" wrote:

I thought the formulas suggested worked, but in rows where column R fits the
criteria for an X but Column S is blank, an X is not displaying in Column A.
Any other ideas??

"Diane1477" wrote:

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 just checked that and mine and Ryan's both work in that circumstance.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Diane1477" wrote in message
...
I thought the formulas suggested worked, but in rows where column R fits
the
criteria for an X but Column S is blank, an X is not displaying in Column
A.
Any other ideas??

"Diane1477" wrote:

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...