Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a formula: If TIME is or < than a cell enter TEXT
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a formula: If TIME is or < than a cell enter TEXT
11:00 PM until when is considered LATE (that is, at what time during the day
is the break point time between LATE and OK)? Rick "cyndinmarianne" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can we enter at the same time maintain a formula in a cell? | Excel Discussion (Misc queries) | |||
Enter text and formula in a cell | Excel Worksheet Functions | |||
Enter text automatically based on current time | Excel Discussion (Misc queries) | |||
Enter same text in mulitple worksheets at the same time | New Users to Excel | |||
enter time in simple text and convert to hours/minutes | Excel Discussion (Misc queries) |