I have two cells being calculated. I want the the third cell to
automatically fill-in based upon the lesser of those two values.Example:
If cell1 = 5 and cell2 = 7, cell3 should autofill with 5, the lessor of
the twoIf cell1 = 5 and cell2 =3, cell3 sould fill with 3.Formula so far
in layout:if (MaxLoan > MaxLoanLTV) then // NewLoanMaxLoan.presence =
"visible"MaxLoanLTV.presence = "hidden"elseif (MaxLoanLTV > MaxLoan)
thenMaxLoan.presence = "hidden"MaxLoanLTV.presence =
"visible"endifFormula in c...