Thread: AND, MAX
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default AND, MAX

I am working with the formula below. G2 and I2 are dates, or blank. If both
are blank, I would like a blank in the field, if one or both have dates, I
would like the latest date.

=IF(AND(G2,I2)="","",MAX(G2,I2))

Please advise why I get the #Value! error.

Thanks.