Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Max / IF questions
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table questions | Excel Discussion (Misc queries) | |||
A couple of questions... | Excel Discussion (Misc queries) | |||
Where can I post Macro questions? | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Puzzling Format Questions | Excel Discussion (Misc queries) |