LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 89
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Index & Match Question Iriemon Excel Worksheet Functions 2 February 3rd 09 07:17 PM
Question on index Paul B[_3_] Excel Discussion (Misc queries) 3 December 31st 08 07:15 PM
INDEX / MOD() question.. Nastech Excel Discussion (Misc queries) 1 October 17th 08 08:17 AM
Index() & Row() Question mldancing Excel Discussion (Misc queries) 0 April 16th 07 10:34 PM
Index question Ginger Excel Worksheet Functions 3 September 9th 05 03:41 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"