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!

3 Replies