Help with formula!!!
 

I and working on an open-end credit calculator for work and am stuck.
There are multiple lines of credit to choose from and I am trying to
get it so the minimum payment is calculated. That is this formula. I
have seperated the formulas and it works fine, but when i put it all
together, it doesn't work. I have been working on this for days but to
no avail. I need someone to bail me out please!!!

When I input it into a cell, the next to last "IF" is highlighted as
the error. Thanks!!!!

Tom

Here is the formula (It belongs in cell I9):

=IF(H9=C6, IF((I3+I4)*C8C10, (I3+I4)*C8, IF(I3+I4<C10, SUM(I3:I5),
10)),
IF(H9=D6, IF((I3+I4)*D8D10, (I3+I4)*D8, IF(I3+I4<D10, SUM(I3:I5),
10)),
IF(H9=E6, IF((I3+I4)*(E8)E10, (I3+I4)*(E8), IF(I3+I4<E10, SUM(I3:I5),
20)),
IF(H9=F6, IF((I3+I4)*F8F10, (I3+I4)*F8, IF(I3+I4<F10, SUM(I3:I5),
10)),
IF(H9=C11, IF(I3<100.01, IF(I4+I3100, SUM(100+I5), SUM(I4+I3+I5)),
SUM(C13+I5)),
IF(H9=D11, IF(I3<100.01, IF(I4+I3100, (I3+I4)*D13+I5, I4+I3),
SUM(((I3+I4)*D13)+I5)),
IF(H9=E11, IF(I3<100.01, IF(I4+I3100, (I3+I4)*E13+I5, I4+I3),
SUM(((I3+I4)*E13)+I5)),
IF(H9=F11, (I3+I4)*F13+I5, "")))))))

File Attached: http://www.exceltip.com/forum/attach...?postid=291802 (oe-calc.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Help with formula!!!
 

Excel has a limitation as to how many levels can be nested in a function.
It appears your formula is exceeding that limit. The error appears at the
eighth nested function of your formula.

Here is the info from Excel Help:
You can enter, or nest, no more than seven levels of functions within a
function.

A formula can contain up to seven levels of nested functions. When Function
B is used as an argument in Function A, Function B is a second-level
function. If Function B contains Function C as an argument, Function C would
be a third-level function.

Troy

"tjarena18" wrote in message
...
I and working on an open-end credit calculator for work and am stuck.
There are multiple lines of credit to choose from and I am trying to
get it so the minimum payment is calculated. That is this formula. I
have seperated the formulas and it works fine, but when i put it all
together, it doesn't work. I have been working on this for days but to
no avail. I need someone to bail me out please!!!

When I input it into a cell, the next to last "IF" is highlighted as
the error. Thanks!!!!

Tom

Here is the formula (It belongs in cell I9):

=IF(H9=C6, IF((I3+I4)*C8C10, (I3+I4)*C8, IF(I3+I4<C10, SUM(I3:I5),
10)),
IF(H9=D6, IF((I3+I4)*D8D10, (I3+I4)*D8, IF(I3+I4<D10, SUM(I3:I5),
10)),
IF(H9=E6, IF((I3+I4)*(E8)E10, (I3+I4)*(E8), IF(I3+I4<E10, SUM(I3:I5),
20)),
IF(H9=F6, IF((I3+I4)*F8F10, (I3+I4)*F8, IF(I3+I4<F10, SUM(I3:I5),
10)),
IF(H9=C11, IF(I3<100.01, IF(I4+I3100, SUM(100+I5), SUM(I4+I3+I5)),
SUM(C13+I5)),
IF(H9=D11, IF(I3<100.01, IF(I4+I3100, (I3+I4)*D13+I5, I4+I3),
SUM(((I3+I4)*D13)+I5)),
IF(H9=E11, IF(I3<100.01, IF(I4+I3100, (I3+I4)*E13+I5, I4+I3),
SUM(((I3+I4)*E13)+I5)),
IF(H9=F11, (I3+I4)*F13+I5, "")))))))

File Attached: http://www.exceltip.com/forum/attach...?postid=291802
(oe-calc.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/