Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |