Thread: Max if less than, Non-continuious array
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Max if less than, Non-continuious array
Hi,

You may also try this

=if(and(A1<F1,C1<F1,E1<F1),max(A1,C1,E1),"")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ToddEZ" wrote in message
...
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