# #DIV/0! Error

#### oaks15

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

<tbody>
</tbody>

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### Special-K99

##### Well-known Member
Change this to

=(IF(A1=0,100,IF(A2=0,0,(A2-A1)/A1)))

#### oaks15

##### New Member
Thanks Special-K99. The only issue would be if I hired 5 people, the growth would be 500%. Because the number would fluctuate, could I change it too =(IF(A1=0,(A2), IF(A2=0,0,(A2-A1)/A1))) Would this work logically?

#### Special-K99

##### Well-known Member
Shouldn't that be

=(IF(A1=0,A2*100%, IF(A2=0,0,(A2-A1)/A1)))

#### oaks15

##### New Member
Perfect! Thanks for the help. I always make it more difficult than I need to.

Replies
3
Views
432
Replies
6
Views
247
Replies
3
Views
638
Replies
2
Views
335
Replies
1
Views
561

1,195,662
Messages
6,010,992
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back