Thread: Formula that returns late, early or Ok accordingly to the period
View Single Post
  #3   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

Although loking again at what you asked this might not be what you
wanted. If you wanted to test if the completion date was within two
given date ranges

If we assume in A1 is the earliest completion date, B1 is the latest
possible completion date then the formula would be

=if(C1<A1,"Early",if(C1B1,"Late","Ok")

Hope one of the two ideas help?

Regards

Carl


--
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