• 395K Members
• 7,274 Online
• 428K Conversations

## LMI Calc - Formula

Occasional Visitor

# LMI Calc - Formula

Hi!

I am trying to build a simple Lenders Mortgage Insurance Calculator to use, I have made a table where the relevant brackets are in place. Ideally, the calculator would use the loan amount and LVR to find the right rate to use to calculate LMI. I cant seem to figure out how to write out this formula, i was looking at a VLookup function but that may be wrong. I have uploaded the file for reference