if function to test two different things

[jiminchina]

Hi guys,

Thanks for taking the time to read this in advance.

I know what I want the formulas to do and almost know hoe to write it but....

Anyway, I want my if formula to return either "on-time" or "not on-time" depending what's in the box next to it.

So far I have:

=if(e3=<=0 &>-5, "on-time","not on-time")

On-time is between minus 5 and 0, anything else is classed as late. However, it keeps popping up with the formula wizard who is not much help. Hopefully there are some true wizards out there?

Cheers,

Jim

 

[VoG]

Perhaps

=IF(AND(E3<=0,E3>=-5), "on-time","not on-time")

 

[anglais428]

=IF(AND(E3>=-5,E3<=0),"on time","not on time")

 

[jiminchina]

anglais428 and VoG,

Thanks for you help. It's simple when you know how.

Cheers,

Jim