Home

LMI Calc - Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-567260%22%20slang%3D%22en-US%22%3ELMI%20Calc%20-%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567260%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20build%20a%20simple%20Lenders%20Mortgage%20Insurance%20Calculator%20to%20use%2C%20I%20have%20made%20a%20table%20where%20the%20relevant%20brackets%20are%20in%20place.%20Ideally%2C%20the%20calculator%20would%20use%20the%20loan%20amount%20and%20LVR%20to%20find%20the%20right%20rate%20to%20use%20to%20calculate%20LMI.%20I%20cant%20seem%20to%20figure%20out%20how%20to%20write%20out%20this%20formula%2C%20i%20was%20looking%20at%20a%20VLookup%20function%20but%20that%20may%20be%20wrong.%20I%20have%20uploaded%20the%20file%20for%20reference%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-567260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-567909%22%20slang%3D%22en-US%22%3ERe%3A%20LMI%20Calc%20-%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-567909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342130%22%20target%3D%22_blank%22%3E%40paddy_stewart1225%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20require%20this%20formula%20in%20E22%20of%20the%20attached%20file%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DVLOOKUP(E21%2CD3%3AI18%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3EMATCH(G20%2CD2%3AI2%2C1)%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E1)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
paddy_stewart1225
Occasional Visitor

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

1 Reply

@paddy_stewart1225 

That would require this formula in E22 of the attached file: 

=VLOOKUP(E21,D3:I18,
MATCH(G20,D2:I2,1),
1)

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies