multiple formulas in one cell
 

I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO" in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15

multiple formulas in one cell
 

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15

multiple formulas in one cell
 

It still comes back with a YES or NO. If no dates is in C then D is blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in cel
D. I have the first part. Example: If Cell A<=Cell B, return "YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date is
found, I want cell D to be blank until a date is filled in cell C. Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15

multiple formulas in one cell
 

Ooops!

Try this:

=IF(ISNUMBER(V163),IF(AND(ISNUMBER(W163),ISNUMBER( X163),W163<=X163),"Yes","No"),"")

Biff

"roy.okinawa" wrote in message
...
It still comes back with a YES or NO. If no dates is in C then D is
blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in
cel
D. I have the first part. Example: If Cell A<=Cell B, return
"YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date
is
found, I want cell D to be blank until a date is filled in cell C.
Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15

multiple formulas in one cell
 

That did it.

Thank you.

"Biff" wrote:

Ooops!

Try this:

=IF(ISNUMBER(V163),IF(AND(ISNUMBER(W163),ISNUMBER( X163),W163<=X163),"Yes","No"),"")

Biff

"roy.okinawa" wrote in message
...
It still comes back with a YES or NO. If no dates is in C then D is
blank.
Current formula in cell:

=IF(AND(ISNUMBER(W163),ISNUMBER(X163),W163<=X163,I SNUMBER(V163)),"Yes","No")

"Biff" wrote:

Hi!

Try this:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1),A1<=B1,ISNUMBER( C1)),"Yes","No")

Biff

"roy.okinawa" wrote in message
...
I want to look at data in three cells A,B,C, that result in a answer in
cel
D. I have the first part. Example: If Cell A<=Cell B, return
"YES","NO"
in
cell D

Now what I want it also to do is look in Cell C for a date. If no date
is
found, I want cell D to be blank until a date is filled in cell C.
Which
would result in a YES or NO

A B C D
31 15 11/10/2005 NO
15 15