N
Norm
Have I missed something here?
=IF(E13>0,"early",E13<0,"late")
Cheers!!
=IF(E13>0,"early",E13<0,"late")
Cheers!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
Iriemon
=IF(E13>0,"Early",if(E13=0,"","late")
N
Norm
Thanks,
E13 is a time value.. if E13 has a value of 12:30 and early is before 12:00
and late is after 12:45 and 12:00 to 12:45 is On Time how would I formula
this?
Cheers!!
E13 is a time value.. if E13 has a value of 12:30 and early is before 12:00
and late is after 12:45 and 12:00 to 12:45 is On Time how would I formula
this?
Cheers!!
R
Ron Rosenfeld
Have I missed something here?
=IF(E13>0,"early",E13<0,"late")
Cheers!!
=if(e13>0,"early",if(e13<0,"late","on time"))
--ron
B
bala_vb
Ron said:On Wed, 19 May 2010 10:14:10 -0700, Nor
<[email protected]>
wrote:
-
=if(e13>0,"early",if(e13<0,"late","on time"))
--ron
=if(istext(e13),"Non Numeri
value",if(e13>0,"early",if(e13<0,"late","on time")))
all the bes