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.
<tbody>
</tbody>
A1 | A2 | A3 | A4 |
0 | 1 | 1 | IF(A2=0,"0"), (A2-A1/A1) |
Employees at start | Hired | Fired | Growth |
<tbody>
</tbody>