# ltv

1. ### LTV Maximum Loan

Hi, this should be really simple but it's hurting my head. I have a known amount of savings (lets say £50,000) and some known LTV percentages from a mortgage company. 70% LTV Interest Only 75% LTV Part & Part 85% LTV Repayment I would like to know the maximum loan amount based on the...
2. ### Camparing against multiple criteria

Please help with a formula I'm trying to work out. I'm trying to return a 'Pass' or 'Fail result based on the following. My criteria is below. A = Loan + Interest B = Loan to Value (%) inc Interest C = Max Loan @ 75% (£750,000) D = Max Loan @ 70% (£1,000,000) E = Max LTV 75% F = Max LTV...
3. ### Conditional Formatting? Hidden formula in the 2 cells that works if you delete or change data.

I have two cells with basic formula. But you can either enter data in one cell and the other cell will populate the data and vice versa. I can even delete both without deleting the formulas. Is this from Conditional Formatting? If so how? For Example I have Cell 1 as “Initial Loan amount”...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back