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 two
If cell1 = 5 and cell2 =3, cell3 sould fill with 3.
Formula so far in layout:
if (MaxLoan > MaxLoanLTV) then // NewLoan
MaxLoan.presence = "visible"
MaxLoanLTV.presence = "hidden"
elseif (MaxLoanLTV > MaxLoan) then
MaxLoan.presence = "hidden"
MaxLoanLTV.presence = "visible"
Formula in calculate:
$ = sum(MaxLoan) // NewLoan
$ = sum(MaxLoanLTV) // NewLoan
It does reflect a number but not the minimum value.
Thank you, worked great!