View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brandon Brandon is offline
external usenet poster
 
Posts: 58
Default Help with formula

I want to return the first date in which the sum of the previous columns
first exceeds inventory on hand (total). Should return 4/5 on this example.

Total Due Date 3/24 3/30 4/5 4/7 4/7
68 #N/A 10 50 20 30 30

I am using nested if's, but need to expand to more than 7 columns, using
excel 2003.

Thanks