We need to aa formula to maintain a certain level of licenses, 5 on hand at all times. The formula involves only 2 cells. When the value of a cell falls below 5 increase the next cell by 1 or which ever number is needed to get it to 5. Hope this makes since.
Example: Each row is a separate example.
Appreciate any help or guidance.
Regards,
Kevin S.
Example: Each row is a separate example.
Available | Needed | Example |
5 | 0 | If 5 no increase |
4 | 1 | If 4, increase by 1 |
3 | 2 | If 3, increase by 2 |
0 | 5 | If 0, increase by 5 |
-5 | 10 | If -5, increase by 10 |
Appreciate any help or guidance.
Regards,
Kevin S.