mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi All,
How can I shorten these 2 formulas
I have the same multiple or conditions and was hoping I can make this slicker and more easier to condense it down as the condition could grow
Many Thanks
How can I shorten these 2 formulas
VBA Code:
=IF(OR([@[Team Manager]]="Matt Gritton Team Blue2000",[@[Team Manager]]="Matt Gritton Team Green2000",[@[Team Manager]]="Academy2000"),"CS_ACADEMY",IF(OR([@[Team Manager]]="Matt Gritton Team Blue2001",[@[Team Manager]]="Matt Gritton Team Green2001",[@[Team Manager]]="Academy2001"),"CS_ACADEMY",IF(OR([@[Team Manager]]="Matt Gritton Team Blue2003",[@[Team Manager]]="Matt Gritton Team Green2003",[@[Team Manager]]="Academy2003"),"CS_ACADEMY",IF(OR([@[Team Manager]]="Matt Gritton Team Blue4000",[@[Team Manager]]="Matt Gritton Team Green4000",[@[Team Manager]]="Academy4000"),"COSC_ACADEMY",[@[Team Manager]]))))
VBA Code:
=IFERROR(SUMPRODUCT(--(tbl_Agent_Results[AHT]),--(tbl_Agent_Results[contactsHandled]),--(tbl_Agent_Results[Date_]=I$5),(--(tbl_Agent_Results[Team Manager]="MATT GRITTON TEAM GREEN4000")+--(tbl_Agent_Results[Team Manager]="MATT GRITTON TEAM BLUE4000")+--(tbl_Agent_Results[Team Manager]="Academy4000")))/SUMPRODUCT(--(tbl_Agent_Results[contactsHandled]),--(tbl_Agent_Results[Date_]=I$5),(--(tbl_Agent_Results[Team Manager]="MATT GRITTON TEAM GREEN4000")+--(tbl_Agent_Results[Team Manager]="MATT GRITTON TEAM BLUE4000")+--(tbl_Agent_Results[Team Manager]="Academy4000"))),"")
I have the same multiple or conditions and was hoping I can make this slicker and more easier to condense it down as the condition could grow
Many Thanks