Help with Custom Calculation Script

I am trying to create a script to calculate the following:

h=80% up to $1 million, 75% for loan amounts > $1 million and < $1.5 million

This topic has been closed for replies.

Legend

Can you provide us with more information on the purpose of this script? Are you planning to run this script in Adobe XD?

Participant

This is how I have it worded in my worksheet:

= $ • Total Acquisition

x MAX LTV Max LTV: 80% up to $1M, 75% for loan amounts > $1M and ≤ $1.5M

= $ • Calculated Acquisition Loan Amount (Amount will be limited to $1.5M)

So, if the Total Acquisition is < $1 million, my calculation would be 80%

and if >$1 million, 75%.

Legend

Thank you. And you are planning to use this script in Adobe XD? I do not know of a way to do that. Hopefully someone else here has a better idea.

Sign up