I am encountering an issue with the #DIV/0! error. My formula is working fine, the problem is that I need to divide by zero, and I am not sure how to write a formula to do that. As you can see below, to get a result, I need to divide by zero. I need to work out turnover percentage, so need to divide 1 by 0 to get 100% turnover. If I have not explained very well, let me know and I will try again.
|Employees at start||Hired||Fired||Growth|