Thread: Formula that returns late, early or Ok accordingly to the period
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mr_teacher mr_teacher is offline
external usenet poster
  
Posts: 1
Default Formula that returns late, early or Ok accordingly to the period

If we assume that the expected date of completion is in A1 and the
actual date of completion is in B1 then the formula you want should be


=IF(B1-A1<0,"Early",IF(B1-A1=0,"Ok","Late"))

Hope that is what you wanted?

Regards

Carl

leslieyosbe Wrote:
I need a formula to automatically calculate if the Job was completed in
the
date range that was provided, and to return Early, Late or Ok
accordingly.


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=567972

Reply With QuoteReply With Quote