Excel for romanhords.com 365 Excel for romanhords.com 365 for Mac Excel for the website Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel for ipad Excel Web phầm mềm Excel for iPhone Excel for apk tablets Excel 2010 Excel 2007 Excel for Mac 2011 Excel for game android phones Excel for Windows Phone 10 Excel thiết bị di động Excel Starter 2010 More...Less

romanhords.com Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula lượt thích =5/0, or when a formula refers lớn a cell that has 0 or is blank, as shown in this picture.

Bạn đang xem: Tables of ordinary bessel functions of the second kind of orders 0 through 9


To correct the error, do any of the following:

Make sure the divisor in the function or formula isn’t zero or a blank cell.

Change the cell reference in the formula to another cell that doesn’t have a zero (0) or blank value.

Enter #N/A in the cell that’s referenced as the divisor in the formula, which will change the formula result to lớn #N/A khổng lồ indicate the divisor value isn’t available.

Many times the #DIV/0! error can’t be avoided because your formulas are waiting for đầu vào from you or someone else. In that case, you don’t want the error message khổng lồ display at all, so there are a few error handling methods that you can use to suppress the error while you wait for input.

Evaluate the denominator for 0 or no value

The simplest way to suppress the #DIV/0! error is to use the IF function khổng lồ evaluate the existence of the denominator. If it’s a 0 or no value, then show a 0 or no value as the formula result instead of the #DIV/0! error value, otherwise calculate the formula.

For example, if the formula that returns the error is =A2/A3, use =IF(A3,A2/A3,0) to lớn return 0 or =IF(A3,A2/A3,””) to return an empty string. You could also display a custom message like this: =IF(A3,A2/A3,”Input Needed”). With the QUOTIENT function from the first example you would use =IF(A3,QUOTIENT(A2,A3),0). This tells Excel IF(A3 exists, then return the result of the formula, otherwise ignore it).


Use IFERROR to lớn suppress the #DIV/0! error

You can also suppress this error by nesting your division operation inside the IFERROR function. Again, using A2/A3, you can use =IFERROR(A2/A3,0). This tells Excel if your formula evaluates lớn an error, then return 0, otherwise return the result of the formula.

For versions of Excel prior to Excel 2007, you can use the IF(ISERROR()) method: =IF(ISERROR(A2/A3),0,A2/A3) (See IS functions).

Note: both the IFERROR & IF(ISERROR()) methods are blanket error handlers, in that they will suppress all errors, not just #DIV/0!. You need lớn make sure your formula works properly before applying any error handling, otherwise you might not realize that your formula isn’t working as you expect.

Tip: If error checking is turned on in Excel, you can click

next to lớn cell that shows the error. Click Show Calculation Steps if it’s available, và pick the resolution that works for your data.

Xem thêm: Soạn Bài Ôn Tập Truyện Kí Việt Nam 8 : Ôn Tập Truyện Kí Việt Nam

Need more help?

You can always ask an expert in the Excel Tech Community or get tư vấn in the Answers community.