Max / IF questions

[Guest]

Hi ..
I am using the following formula to calculate the last date i had a meeting
with a customer .. =MAX(IF('Contact Details'!D5468="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

 

[Guest]

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

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