+7I 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?
+12@DinaF ....you can use the If statement, (assuming PurchasePrice, AppraisalValue and CurrentBalance are either form controls or Item Properties), see below:
If(lessThanOrEqual(PurchasePrice,AppraisalValue), CurrentBalance/PurchasePrice, CurrentBalance/AppraisalValue)
Above statement will:
Please mark this as a solution if it works for you.
+7Thank you! This is perfect!! I don't think they are ever equal but will check on that. Thanks again!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.