Quote Originally Posted by Sambo kid View Post
based on what you wrote AND what you posted, this will work...
=IF(AND(B9="75%",C9<10000000),1000000,IF(AND(B9="70%",C9<1500000),1500000,IF(AND(B9="65%",C9<2000000),2000000,"")))
or essentially the same but w/o the blank...
=IF(AND(B9="75%",C9<10000000),1000000,IF(AND(B9="70%",C9<1500000),1500000,IF(AND(B9="65%",C9<2000000),2000000)))


Sambo, it does work, however, its rounding even when its not supposed to....

e.g. when after improved is 1400000, it multiples 75% like it should, which gives the loan amount of 1050000. However the E9 cell that is to round only when multiplied by 75 AND the result is LESS THAN 1000000, so it should be staying as 1050000 because it is not LESS THAN 1000000...