| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas within Cell References | Excel Discussion (Misc queries) | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
| Entering multiple formulas in one cell | Excel Worksheet Functions | |||
Hybrid Mode
