Remove the DIV#/0! Error in Excel

UNDERSTAND & FIX EXCEL ERRORS: Download our free pdf
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

The DIV#/0! error occurs in Excel when you are dividing something by 0 or by cell that is currently empty. The error can be suppressed by using IFERROR or IF. The video takes you through some examples where the DIV#/0 might occur in your worksheets.

-------------------------------------------
------------------------

[fidzer]

Thanks.
Just getting my head around Excel now and this was extremely useful.

[kellywilson]

Really easy to follow. I fixed my error even before the video had finished! Thank you

[burakm]

Dude thank you so much. Been trying to complete this financial model and finally only figured the iferror method after watching this. Lifesaver!

[siddarthbhat]

The referencing was a beautiful technique brought up. All videos on YouTube as far as I saw showed only the IFERROR or IF condition

[lukasschallibaum]

Thank you! We need more people like you

[MelodieKate]

Been looking for a simple fix and you have nailed it! Easy to understand and easy to fix - when it is explained! A Million THANKS!!

[Delekham]

Great Video, and it helped me alot. Thumbed it up for you!

[NotMe]

It is still very helpful in 2020, thank you.

[dannyboy]

Nice tip Chester, just what I needed to tune up my spreadsheet....thx

[MrSEYHA]

Thank you so much. i've solved my problem now.

[SuperNoobInp]

Thank you for such a great tutorial, but I have a question, my problem is the one like you showed last, meaning that the values have not been entered yet. The problem that those cells already contain another another formula, for example =AVERAGEIF(B28:M28, "<>0") where or how do I add in the IFERROR?

[woriwins]

Thank you so much. This saved me big time.

[purityrima]

Thank you really. You are the best! Your video saved me!

[shankarsarodenarayan]

Thanks Friend for the Effort on the Video

[tilewareproducts]

Praise the Lord Jesus for you and these solutions... thank you for publishing!

[marias]

This is very helpful. But you can try to zoom out the view so it would be more clear to viewers.😊

[ajaykumarsingh]

Best Video.
Solved my issue.

Thanks a lot buddy, keep up the good work.

[BRYCEandWESfishing]

In your example, it works if you are dividing two numbers. But what if your end block should include the average of 3 numbers?

[dx]

Hi Chester Tugwell,
I tried to remove or change the shape of error (#0/DIV!) that appear with equation (= 1000 / 0-1) but to no avail
!
I know the equation mathematically is wrong, but I want to change the error shape from #0/DIV! to 0 if it is possible

thank you

[Beautiful.Locations.and.people]

Thanks a lot. Your video helped me to resolve the error.