Thread: Max if less than, Non-continuious array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Max if less than, Non-continuious array
=IF(TODAY()<F1,MAX(A1,C1,E1),"")
--
If this post helps click Yes
---------------
Jacob Skaria


"ToddEZ" wrote:

I have dates in cells A1, C1, and E1. Cell F1 = 1/1/2009.

What formula can I use to find the maximum of cells A1, C1, and E1 IF AND
ONLY IF the date is is earlier than F1?


Reply With QuoteReply With Quote