Texas Longhorn
Active Member
- Joined
- Sep 30, 2003
- Messages
- 493
Hi,
I have a workbook that models out production for an oil well. Column A is "Period", measured in days. Column F is "Cumulative NPV", measured in dollars. In cell N1, I have an initial well cost ($800,000). In cell O1, I would like to return the period number from Column A at which the cumulative NPV in column F first exceeds the initial well cost in cell N1.
I've been trying combinations of INDEX and IF, but have not had any luck. Any help is much appreciated.
Thanks,
Bill
I have a workbook that models out production for an oil well. Column A is "Period", measured in days. Column F is "Cumulative NPV", measured in dollars. In cell N1, I have an initial well cost ($800,000). In cell O1, I would like to return the period number from Column A at which the cumulative NPV in column F first exceeds the initial well cost in cell N1.
I've been trying combinations of INDEX and IF, but have not had any luck. Any help is much appreciated.
Thanks,
Bill