| 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) | |||
Linear Mode
