View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich P Rich P is offline
external usenet poster
 
Posts: 1
Default Finding the date in a table when one value first exceeds another.

I have a table with three columns which show a date, balance owed and savings
respectively. Im trying to find a cell formula that returns the date of the
first instance where the savings exceeds the balance, i.e. gives me the date
I could pay the balance off. In this example it would be 01/05/08.

01/01/08 65000 62000
01/02/08 64500 62260
01/03/08 64000 62520
01/04/08 63500 62780
01/05/08 63000 63040
01/06/08 62500 63300

At present I have a formula in a fourth column saying =if(CnBn,An,"") then
in my cell put the formula =min(D1:D100). This works but is there a neater
way without having the fourth column?