ExcelBanter - Quick formula help please

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Quick formula help please (https://www.excelbanter.com/excel-discussion-misc-queries/264120-quick-formula-help-please.html)

Norm

Quick formula help please

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

Cheers!!

Iriemon

Quick formula help please

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

"Norm" wrote:

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

Cheers!!

Norm

Quick formula help please

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

"Norm" wrote:

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

Cheers!!

Ron Rosenfeld

Quick formula help please

On Wed, 19 May 2010 10:14:10 -0700, Norm
wrote:

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

Cheers!!

=if(e130,"early",if(e13<0,"late","on time"))
--ron

bala_vb

Quote:

Originally Posted by Ron Rosenfeld (Post 954840)

On Wed, 19 May 2010 10:14:10 -0700, Norm
wrote:

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

Cheers!!

=if(e130,"early",if(e13<0,"late","on time"))
--ron

=if(istext(e13),"Non Numeric value",if(e130,"early",if(e13<0,"late","on time")))

all the best

bala_vb

Quote:

Originally Posted by Ron Rosenfeld (Post 954840)

On Wed, 19 May 2010 10:14:10 -0700, Norm
wrote:

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

Cheers!!

=if(e130,"early",if(e13<0,"late","on time"))
--ron

=if(istext(e13),"Non Numeric value",if(e130,"early",if(e13<0,"late","on time")))

istext verify whether content in e13 is numeric or text.

all the best

All times are GMT +1. The time now is 09:13 PM.