loan to value function?

K

KenWagnerRealtor

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.
 
R

Rick Rothstein

Put the formula into the first cell it applies to and then copy it down the
column as far as it will be needed. To prevent errors for rows where there
is no data yet, use this version of the formula instead...

=IF(AE1="","",(AR1+AS1)/AE1)
 
K

KenWagnerRealtor

Thanks Rick, That worked great!

Rick Rothstein said:
Put the formula into the first cell it applies to and then copy it down the
column as far as it will be needed. To prevent errors for rows where there
is no data yet, use this version of the formula instead...

=IF(AE1="","",(AR1+AS1)/AE1)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Financial function - calculating loans with deferred payments 2
FV Function (Excel) 3
Date function within loan amortization spreadsheets 4
PPMT Function 4
loan payment 2
Display in a selected cell the 1st negative value's matching date 1
If Function with multiple criteria 2
Loan Compound Interest Function 2

Top