Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Question
I have a (I hope) simple question regarding the INDEX function. I have a
spreadsheet that calculates a mortgage schedule similar to this(some columns have been deleted to get it into this space): No. Payment Date Ending Balance 1 9/1/2008 $78,196.73 2 10/1/2008 78,122.08 3 11/1/2008 78,047.04 4 12/1/2008 77,971.60 5 1/1/2009 77,895.78 6 2/1/2009 77,819.56 7 3/1/2009 77,742.94 8 4/1/2009 77,665.92 etc. I would like to find the payment number (column A) where the ending balance is <=0 Any help would be appreciated. Thanks Iriemon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index & Match Question | Excel Worksheet Functions | |||
Question on index | Excel Discussion (Misc queries) | |||
INDEX / MOD() question.. | Excel Discussion (Misc queries) | |||
Index() & Row() Question | Excel Discussion (Misc queries) | |||
Index question | Excel Worksheet Functions |