T
tjarena18
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)*C8>C10, (I3+I4)*C8, IF(I3+I4<C10, SUM(I3:I5),
10)),
IF(H9=D6, IF((I3+I4)*D8>D10, (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)*F8>F10, (I3+I4)*F8, IF(I3+I4<F10, SUM(I3:I5),
10)),
IF(H9=C11, IF(I3<100.01, IF(I4+I3>100, SUM(100+I5), SUM(I4+I3+I5)),
SUM(C13+I5)),
IF(H9=D11, IF(I3<100.01, IF(I4+I3>100, (I3+I4)*D13+I5, I4+I3),
SUM(((I3+I4)*D13)+I5)),
IF(H9=E11, IF(I3<100.01, IF(I4+I3>100, (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/attachment.php?postid=291802 (oe-calc.xls)
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)*C8>C10, (I3+I4)*C8, IF(I3+I4<C10, SUM(I3:I5),
10)),
IF(H9=D6, IF((I3+I4)*D8>D10, (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)*F8>F10, (I3+I4)*F8, IF(I3+I4<F10, SUM(I3:I5),
10)),
IF(H9=C11, IF(I3<100.01, IF(I4+I3>100, SUM(100+I5), SUM(I4+I3+I5)),
SUM(C13+I5)),
IF(H9=D11, IF(I3<100.01, IF(I4+I3>100, (I3+I4)*D13+I5, I4+I3),
SUM(((I3+I4)*D13)+I5)),
IF(H9=E11, IF(I3<100.01, IF(I4+I3>100, (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/attachment.php?postid=291802 (oe-calc.xls)