If question

[jackdiamond]

Hi, at the moment, I have the following formula. I want to also add abit for "ON TIME". So if J7 is exactly the same as N7, I would like it to return the result "ON TIME"

= IF ( N7 < J7 , " YES " , " NO " )


Is thi an easy job?

Any help appreciated.

Ta
Stu

 

[Tuelor]

=(j7=n7,"on time,"late")

 

[jackdiamond]

Hi Tuelor,

Thanks for your help although maybe I didn't word it correctly:

I wanted the "on time" bit aswell as the Yes, no part

Can this be done?

 

[Aladin Akyurek]

Hi, at the moment, I have the following formula. I want to also add abit for "ON TIME". So if J7 is exactly the same as N7, I would like it to return the result "ON TIME"

= IF ( N7 < J7 , " YES " , " NO " )


Is thi an easy job?

Any help appreciated.

Ta
Stu

Try...

=IF(N7 = J7, "ON TIME", IF(N7 < J7, "YES", "NO"))

 

[jackdiamond]

ACE.

thanks
Stu