Simplification of IF formula

[excel_learner]

I have little complex formula in the attached file that i want to make it simple, kindly assist.

Thanks
Attachment 68

bonds interest.xlsx

[Admin]

Hi,

May be..

=IFERROR(SUMPRODUCT(--(A36>=A12:A33),C12:C33)+(INDEX(C12:C33,MATCH(A36,A 12:A33)+1)/(INDEX(A12:A33,MATCH(A36,A12:A33)+1)-INDEX(A12:A33,MATCH(A36,A12:A33)))*(A36-INDEX(A12:A33,MATCH(A36,A12:A33)))),SUM(C12:C33))

HTH

[excel_learner]

Thanks, it works, anyother simpler version...

[Haseeb A]

Hello, Try this,

=IFERROR(SUMIF(A12:A33,"<="&A36,C12:C33)+(INDEX(C1 2:C33,MATCH(A36,A12:A33,1)+1)/(INDEX(A12:A33,MATCH(A36,A12:A33,1)+1)-LOOKUP(A36,A12:A33)))*(A36-LOOKUP(A36,A12:A33)),SUM(C12:C33))

[excel_learner]

thanks,