Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating rents and months past in 1 cell???
Hi,
I´m making a Worksheet to calculate the Residual Value of car at the time the worksheet is open. So i have colums with the "inicial date of the contract", "Final date of the contract", "the monthly rent", and the "car value when purchased". With this colums i need to calculate the value of the car at today date. This columm as to do this: "Value of the car when Purchased" - (MINUS) "rents payed since the begining of the contract until todays date". How can i make excel calculate this. Sincerely |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating rents and months past in 1 cell???
To find out the number of months, you would use this formula... =(YEAR(NOW())-YEAR(A1))*12+MONTH(NOW())-MONTH(A1) What you need to do is put ="Value of the car when purchased"-("the monthly rent"*(YEAR(NOW())-YEAR(A1))*12+MONTH(NOW())-MONTH(A1) Make sure you format the cell as general -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=556481 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating rents and months past in 1 cell??? | Excel Discussion (Misc queries) |