Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
Calculating Rents and Months past in 1 cell???
This either sounds like a beginners question or a general question. I would
not use a macro for this. "Ricardo Barroso" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating months with half months. | Excel Discussion (Misc queries) | |||
Calculating rents and months past in 1 cell??? | New Users to Excel | |||
Calculating rents and months past in 1 cell??? | Excel Discussion (Misc queries) | |||
Graphing past months (totals) and current month (weekly total) in | Charts and Charting in Excel | |||
Dates to months and calculating values for their months | Excel Programming |