Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mortgage calculator: finish date?
I have a mortgage calculator which calculates the outstanding amount on a
daily basis. This gives me a huge column of figures, which eventually turns negative somewhere around the middle, depending on how much I am repaying! I would like to put a single cell at the top of the spreadsheet which identifies the 'Mortgage Liberation Day" by referencing the cell where the outstanding balance drops below zero. I've tried VLOOKUP, but can't seem to get the formula right. Any help will be much appreciated! - Column A is entirely formatted as dates, and column F is the outstanding balance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions |