Forum Discussion
How to Use Existing Value in a Column to Predict when a Specific Value Will be Reached or Exceeded
It has been decades since I use Excel on a daily basis; so I have forgotten a lot that I once knew. I use it nowadays only for household tracking. I have a workbook wherein I track electricity c...
JoseKOwl wrote: ``predict when their sum will reach or exceed 1,000 kilowatts``
Wow, just 1000 kWh?! Your usage must be a lot more frugal than mine. Good for you!
Is this what you want?
Formulas:
C2: =IF(B2="", "", SUM($B$2:B2)))
D3: =IF(B3="", "", INT(FORECAST(1000, $A$2:A3, $C$2:C3)))
Copy C2 and D3 down their columns
Format D3:D8 etc as some form of Date; otherwise, you will see an integer