Remove part of a calculation from a formula

[jenstrymecki]

How to I adjust the following forumula to stop cell AL3 from factoring in AP1?

=IF(B10="N/A",0,IF(OR('Client Information'!$E$16="Canada",'Client Information'!$I$16="Canada"),IF(P10<$AL$2,P10*$AL$3*((1+$AP$1)^(A10-$A$9)),$AL$2*$AL$3*((1+$AP$1)^(A10-$A$9))),"N/A"))

[rorya]

Do you mean:

=IF(B10="N/A",0,IF(OR('Client Information'!$E$16="Canada",'Client Information'!$I$16="Canada"),IF(P10<$AL$2,P10*$AL$3,$AL$2*$AL$3),"N/A"))

[jenstrymecki]

Close - however I still need AL2 to factor in AP1 though....

[rorya]

Put the last part back as it was then:

=IF(B10="N/A",0,IF(OR('Client Information'!$E$16="Canada",'Client Information'!$I$16="Canada"),IF(P10<$AL$2,P10*$AL$3,$AL$2*$AL$3*((1+$AP$1)^(A10-$A$9))),"N/A"))