Forum Discussion
Help with Conditional Function
I need assistance creating a conditional function for a unique calculation. The Scenario is as follows: For a given month I have a "Hurdle" that must be overcome for progress. EG the hurdle i...
This is exactly what I was looking for!
Is there anyway to ensure that Column E (Cumulative Credit) cannot go negative. That may be the only pit fall to the set up. If at any point that column were to go negative it could throw off Column D "Credit"
Is there anyway to ensure that Column E (Cumulative Credit) cannot go negative. That may be the only pit fall to the set up. If at any point that column were to go negative it could throw off Column D "Credit"
The formula in column D ensures that the cumulative credit in column E never becomes negative
- awesome, thank you very much for help!