2 Replies Latest reply on Apr 1, 2013 1:14 PM by NY2CA

    Auto-Fill in of minimum value

    NY2CA

      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"

      endif

       

      Formula in calculate:

       

      $ = sum(MaxLoan) // NewLoan

      $ = sum(MaxLoanLTV) // NewLoan

       

      It does reflect a number but not the minimum value.

       

      Thank you.