Can someone tell me the best way to do this?

vovens

New Member
Joined
Nov 18, 2005
Messages
1
I'm trying to figure out the best formula to use in this situation.

LTV % 30 yr yearly prem
95.01 0.0096 $1,689.60
90.01 0.0078 $1,372.80
85.01 0.0052 $915.20
80.01 0.0032 $563.20

This is the table that I'm trying to use. I have a formula that will calculate the loan to value on a mortgage. If it's greater than 80%, I want it to reference this table (actual LTV >= LTV in table) and then plug in the appropriate yearly premium for the LTV calculated (this is for calculating yearly PMI premium). If the LTV is less than the % listed in the column, I want to return a value of 0.

I've tried the IF (always came back FALSE) and got a #NA when I used VLOOKUP. You're talking to a novice and I know just enough to get frusterated when I can't get the results I'm looking for.

I've been lurking for the last few days and can't seem to find the help I needed, so now, I'm asking.

Thanks,
Victoria
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Hi Vovens , Welcome To The Board,

Check out the "RATE" function in Excel Help !!!

Also search for "PV" function for personel finance
help.

It should start you off with your quest !!!!!

Hope this helps !!!

Russ.
 
Upvote 0

Forum statistics

Threads
1,212,139
Messages
6,106,179
Members
448,004
Latest member
Umberto

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top