Calculating Max Loan Amount based on Criteria

[mecerrato]

I have the following formula that calculates the maximum loan/line amount that a borrower qualifies for based on some criteria. The formula works fine but I would like to add a maximum limit based on another formula

This is the formula I currently have that calculates properly the maximum loan/line amount:
=IFERROR(IF(G15>G14,"",PV(G12/12,240,G13-((C19+G13)-(C20*G14)))*-1)-1,"")

I want to add functionality to cap the maximum line/loan amount at 90% of the value minus 1st mortgage balance, so the formula that I need to act as a cap is (C9*90%)-C10.

Can someone help me figure this out?

 

[BadgerRoad]

Wouldn't it just be the minimum of the Max Line amount and the cap?
Specifically, =MIN(IFERROR(IF(G15>G14,"",PV(G12/12,240,G13-((C19+G13)-(C20*G14)))*-1)-1,""), (C9*90%-C10))

 

[mecerrato]

Wouldn't it just be the minimum of the Max Line amount and the cap?
Specifically, =MIN(IFERROR(IF(G15>G14,"",PV(G12/12,240,G13-((C19+G13)-(C20*G14)))*-1)-1,""), (C9*90%-C10))

This worked perfectly, I could not get the syntax right, thanks.