Is there any easy way or existing tool that enables you to look at and resolve long complex formulas i.e.
=IF($I1273="Bmk",AW1273,IF(ISNUMBER(AJ1273),AJ1273,IF(AND($I1273="GenFollowerDerv",$B1273=1),BI1273,IF(LEFT($I1273,11)="GenFollower",IF(INDEX(rgCurveSpreadORides,MATCH($J1273,rgCurveIDs,0),MATCH(AW$9,rgCurveSpreadORidesColHeaders,0))="",((SUMIF(rgCurveIDs,$J1273,OFFSET(rgCurveSpreads,0,MATCH(BU$9,rgCurveSpreadsColHeaders,0)-1,ROWS(rgCurveSpreads),1))/(COUNTIF(rgCurveIDs,$J1273)-1))*INDEX(rgCurveScaleFactors,MATCH($J1273,rgCurveIDs,0),MATCH(BU$11,rgCurveScaleFactorsColHeaders,0))+INDEX(rgCurveTweakFactors,MATCH($J1273,rgCurveIDs,0),MATCH(BU$11,rgCurveTweakFactorsColHeaders,0)))*V1273+AC1273,INDEX(rgCurveSpreadORides,MATCH($J1273,rgCurveIDs,0),MATCH(AW$9,rgCurveSpreadORidesColHeaders,0))*V1273+$AC1273),(SUMIF(rgCurveIDs,$O1273,OFFSET(rgCurveSpreads,0,MATCH(BU$9,rgCurveSpreadsColHeaders,0)-1,ROWS(rgCurveSpreads),1))/(COUNTIF(rgCurveIDs,$O1273)-1))*V1273+$AC1273))))
=IF($I1273="Bmk",AW1273,IF(ISNUMBER(AJ1273),AJ1273,IF(AND($I1273="GenFollowerDerv",$B1273=1),BI1273,IF(LEFT($I1273,11)="GenFollower",IF(INDEX(rgCurveSpreadORides,MATCH($J1273,rgCurveIDs,0),MATCH(AW$9,rgCurveSpreadORidesColHeaders,0))="",((SUMIF(rgCurveIDs,$J1273,OFFSET(rgCurveSpreads,0,MATCH(BU$9,rgCurveSpreadsColHeaders,0)-1,ROWS(rgCurveSpreads),1))/(COUNTIF(rgCurveIDs,$J1273)-1))*INDEX(rgCurveScaleFactors,MATCH($J1273,rgCurveIDs,0),MATCH(BU$11,rgCurveScaleFactorsColHeaders,0))+INDEX(rgCurveTweakFactors,MATCH($J1273,rgCurveIDs,0),MATCH(BU$11,rgCurveTweakFactorsColHeaders,0)))*V1273+AC1273,INDEX(rgCurveSpreadORides,MATCH($J1273,rgCurveIDs,0),MATCH(AW$9,rgCurveSpreadORidesColHeaders,0))*V1273+$AC1273),(SUMIF(rgCurveIDs,$O1273,OFFSET(rgCurveSpreads,0,MATCH(BU$9,rgCurveSpreadsColHeaders,0)-1,ROWS(rgCurveSpreads),1))/(COUNTIF(rgCurveIDs,$O1273)-1))*V1273+$AC1273))))