Hi all,

Here's my dilemma:

As you can see, it's a 5x5 matrix and values on this particular cell need to follow the formula seen in the code. The problem is that I can only get to a the third condition (00100) before Excel stops and tells me that I have entered too many arguments into the equation.

Would it help if I were to do the calculations on another cell and then just reference the equation there?

For example, I would move the formula:"K451*(Y451/365)" and the other subsequent formulas to other columns and then have the code above choose the proper value off those columns.

i.e.

Thanks in advance!

Here's my dilemma:

Code:

=IF(RIGHT(Matrix,5)="10000",K451*(Y451/365),IF(RIGHT(Matrix,5)="01000",K451+L451*(Y451-(365*2)/365),IF(RIGHT(Matrix,5)="00100",K451+L451+M451*(Y451-(365*3)/365)),IF(RIGHT(Matrix,5)="00010",K451+L451+M451+N451*(Y451-(365*4)/365),IF(RIGHT(Matrix,5)="00001",(K451+L451+M451+N451)+(O451*((Y451-(365*4))/365)))))))

Would it help if I were to do the calculations on another cell and then just reference the equation there?

For example, I would move the formula:"K451*(Y451/365)" and the other subsequent formulas to other columns and then have the code above choose the proper value off those columns.

i.e.

Code:

=IF(RIGHT(Matrix,5)="10000",Z451,)

## Comment