All, wondering if someone can help me with a formula. I need a formula that will calculate the month when total project cost has been spent (e.g. 500 in the table below). In the table below, the correct month is 5.
<tbody>
</tbody>
Thank you in advance for your help.
Chet
Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
Project Cost | | 100 | 100 | 100 | 100 | 100 | | | | | | |
| | | | | | | | | | | | |
Total Project Cost | 500 | | | | | | | | | | | |
Month of Completion | 5 | | | | | | | | | | |
<tbody>
</tbody>
Thank you in advance for your help.
Chet