View Single Post
  #1   Report Post  
roy.okinawa
 
Posts: n/a
Default 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