I am trying to create a calculated formula that compares 2 currency fields, to determine which is the lesser value of the 2 then, use the lesser of the 2 values and divide that value by a 3rd field.
Look at "PurchasePrice" field and the "AppraisalValue" field and determine which is the lesser of the 2. Using the lesser of the 2, divide the "CurrentBalance" field by the lesser value.
=CurrentBalance/whichever the lesser value is.
Can someone help me create that formula?