imback2nite
Board Regular
- Joined
- Oct 30, 2004
- Messages
- 203
- Office Version
- 2003 or older
- Platform
- Windows
Can anyone help with this formula? The Formula on top works but the bottom Formula gives me an error and highlights the CELL in the last phrase. I've been working on it for awhile and barely have any hair left! Can anyone tell me why? Is it too long?
Excel Formula:
=IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AV$1,$AV$2=TRUE),'Quarterly Report'!$AV$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AW$1,$AW$2=TRUE),'Quarterly Report'!$AW$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AX$1,$AX$2=TRUE),'Quarterly Report'!$AX$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))="ri",$AV$1="i",$AV$2=TRUE),"ri",IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))="ri",$AW$1="i",$AW$2=TRUE),"ri","")))))
Excel Formula:
=IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AV$1,$AV$2=TRUE),'Quarterly Report'!$AV$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AW$1,$AW$2=TRUE),'Quarterly Report'!$AW$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))='Quarterly Report'!$AX$1,$AX$2=TRUE),'Quarterly Report'!$AX$1,IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))="ri",$AV$1="i",$AV$2=TRUE),"ri",IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))="ri",$AW$1="i",$AW$2=TRUE),"ri",IF(AND(INDIRECT("'"&$AV$4&"'!"&CELL("address",O12))="ri",$AW$1="i",$AW$2=TRUE),"ri","")))))