Max / IF questions

[G]

Hi ..
I am using the following formula to calculate the last date i had a meeting
with a customer .. =MAX(IF('Contact Details'!D54:D68="Meeting",'Contact
Details'!B54:B68))

The meetings are now reported as "onsite meeting" and "off site meeting" is
there a simple way to add another argument in to the IF statement ??

Thanks

[JMB]

By adding another argument, do you mean to return the last meeting date
(either onsite or off site)?

=MAX(IF('Contact Details'!D54:D68={"Onsite Meeting","Off Site
Meeting"},'Contact Details'!B54:B68))

"G" wrote:

> Hi ..
> I am using the following formula to calculate the last date i had a meeting
> with a customer .. =MAX(IF('Contact Details'!D54:D68="Meeting",'Contact
> Details'!B54:B68))
>
> The meetings are now reported as "onsite meeting" and "off site meeting" is
> there a simple way to add another argument in to the IF statement ??
>
> Thanks