Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, i have this code:
=IF(M5<B5,"Late ","Early ")&TEXT(ABS(M5-B5),"hh:mm:ss") I need it a little more complex. I need the code to look in F5 and if the code find "COS" to know that the reference is in M5. If the code find (ACE) to know that the reference in in L5. After that, the code to look in B5. If the time is smaller than M5 or L5, the result to be "early". If the time is bigger, than the result to display "late". Can this be done? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM IF QUESTION PLEASE HELP | Excel Worksheet Functions | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions |