multiple formulas in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi!

Try this:

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

Biff
 
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,ISNUMBER(V163)),"Yes","No")
 
Ooops!

Try this:

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update cell value based on name and specific date 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
AND formula 2
Copying formulas across columns 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
min if horizontal 0
Lookup multiple cell values and place contents in a single cell 3
DateRange Lookup no exact match, can't use lesser 4

Back
Top