Quick formula help please

[Norm]

Have I missed something here?
=IF(E13>0,"early",E13<0,"late")

Cheers!!

 

[Iriemon]

=IF(E13>0,"Early",if(E13=0,"","late")

 

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

 

[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

 

[bala_vb]

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