View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elaine from South Carolina Elaine from South Carolina is offline
external usenet poster
 
Posts: 1
Default Display in a selected cell the 1st negative value's matching date

I'm preparing an amortization schedule and I want to display at the top of
the worksheet in a designated cell the month/year when the 1st negative value
occurrs in the loan balance column. Then, as I change my payment amounts I
will be able to immediately see the pay-off date result at the top of the
worksheet.