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.
Solved! Go to Solution.
Views
Replies
Total Likes
Topics help categorize Community content and increase your ability to discover relevant content.
Hi,
you have t copy this script in the calculate event of your target field, use Javascript.
this.rawValue = Math.min(num_1.rawValue, num_2.rawValue);
Hope it will helps you,
Mandy
Views
Replies
Total Likes
Hi,
you have t copy this script in the calculate event of your target field, use Javascript.
this.rawValue = Math.min(num_1.rawValue, num_2.rawValue);
Hope it will helps you,
Mandy
Views
Replies
Total Likes
Thank you, worked great!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies