Help with formula please

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

Guest

A B C D E
03/27/2007 11:49 03/27/2007 16:47 True
03/27/2007 21:30 03/27/2007 20:00 False

I'm trying to find out the formula for column E.

I want to determine if the date and time in column A+B is less than the
date and time in Column C+D.

Thank you in advance for your time and help.
Deb
 
Sometimes one of the columns has no data entered, it may be missing the date
and time and so when I drag the formula down column E ....it will give me a
value error. Is there a way for this cell to remain blank if there is no
data to calculate??
 
=IF(AND(A1+B1>0,C1+D1>0),A1+B1<C1+D1,"")

ferde said:
Sometimes one of the columns has no data entered, it may be missing the date
and time and so when I drag the formula down column E ....it will give me a
value error. Is there a way for this cell to remain blank if there is no
data to calculate??
Click to expand...
 
Back
Top