Using Articulate to calculate home loan to value
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!