Hi, I'm trying to develop a worksheet for loan agents to quickly calculate home loan to value to use before they start an application. I have three data entry fields: loan amount, estimated value of the home and purchase price (if applicable). I basically need the system to divide the loan amount by either the estimated value of the home or the purchase price(whichever is lower) to determine the LTV.
I think I can figure out how to do the simple division formula through variables, but I don't know how to make it pick the lower value. Also, I don't want it to pick the purchase price if that is left at 0. Can anyone help? Thanks!
I couldn't verify this because somehow my test file got corrupted, but have a look at the attached screenshot that shows the setup for a simple calculator.
That worked beautifully! The only change I made was after all of the other triggers for the calculate button, I added a trigger to multiply the LTV variable by 100 so it would be a whole percentage. Thanks so much Michael!
3 Replies
I couldn't verify this because somehow my test file got corrupted, but have a look at the attached screenshot that shows the setup for a simple calculator.
That looks like it would work! I'll test it and let you know. Thank you!
That worked beautifully! The only change I made was after all of the other triggers for the calculate button, I added a trigger to multiply the LTV variable by 100 so it would be a whole percentage. Thanks so much Michael!