Calculating Debt service/payment to income ratio with a maximum payment

[murraythek]

I have a formula worked out for financial auto loans but the only problem is I need it to cap out @ $900.

I currently have a table set up where users enter the income (b22), rent (b23), monthly credit card debts (b24) and monthly insolvency debts (if any) (C32). It checks to see that it doesnt exceed our max DSR @ 48 and max PI @ 18.

The formula is hidden on two cells (G35/G36) and is as follows:

DSR: =IF(C32="",(B22*0.48)-B24-B23,(B22*0.48)-B24-B23-C32)
PI: =(B22*0.18)

I then have a cell that is viewable to all user on C17 and the formula is =MIN(G35,G36)

What this does is displays a maximum possible payment for the applicant. The only problem is we have a company policy max of $900 but this formula has no max. To avoid any confusion I need it to stop @ $900. Is this possible?

 

[JustynaMK]

Can you simply modify your formula in cell C17 to:

=MIN(G35,G36,900)

?

In such case, if any of the cells G35/G36 exceeds 900, the cell will display 900 (your maximum). If any of the cells G35/G36 is lower than 900, their respective value will be displayed.