| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
loan to value function?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
loan to value function?
=(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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
loan to value function?
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) -- Rick (MVP - Excel) "KenWagnerRealtor" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
loan to value function?
Thanks Rick, That worked great!
"Rick Rothstein" wrote: 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) -- Rick (MVP - Excel) "KenWagnerRealtor" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate average loan period of a 5 year loan | Excel Worksheet Functions | |||
| is there any way of using a function for loan emi calculation? | Excel Worksheet Functions | |||
| Loan Compound Interest Function | Excel Worksheet Functions | |||
| biweekly payments on a loan using Pmt function | Excel Discussion (Misc queries) | |||
| loan amortization template with loan start date AND first payment | Excel Discussion (Misc queries) | |||
Linear Mode
