loan to value function?
How do I have the function work for the entire column?
"Teethless mama" wrote:
=(AR1+AS1)/AE1
"KenWagnerRealtor" wrote:
Hi,
I'm a bit rusty on excel functions.
1st Loan $ is AR1
2nd Loan $ is AS1
Sale Value is AE1
and mathematically LTV = (1st+2nd)/Sale in a percentage format.
|