Argument Limits

M

mortgagesrus

I am trying to use "IF" statements to figure a value for mortgage insurance
but after a number of statements that work fine, the formula quits working.
Is there a limit on characters or number of arguments.

I have 9 products (they can be grouped into 2 groups) and 4 downpayment
brackets that determine the MI rate, i.e.

30 YR FIXED,80.01-85% down,MI rate is .32% so monthly MI would be (loan
amount*.0032/12)

Any suggestions w/o programming would be appreciated.

Robert
 
A

Alan

No limit on the number of characters as far as I know, but you can only have
seven nested 'IF's. Over this need to use alternatives like VLOOKUP, CHOOSE
etc
Regards,
 
Top