Thread: Need a formula: If TIME is or < than a cell enter TEXT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chua Chua is offline
external usenet poster
  
Posts: 8
Default Need a formula: If TIME is or < than a cell enter TEXT
You can try the formula...

=IF(D11<=D12,"OK","LATE")

Cheers
Chua

"cyndinmarianne" wrote:

Here is my dilemma:
I need a formula to write: If D5 (this will be a time such as 11:00 pm) is <
or = to 11:00 pm enter OK. If D5 is than 11:00 pm enter LATE

I have searched and tried different formulas, nothing seems to be helping.

Any help is appreciated
Reply With QuoteReply With Quote