How To Correct Div0 Error. This is sometimes useful for instance NA errors in a column of data when plotted on a chart show as missing rather than zero. Zu unterdrücken Sie können diesen Fehler auch unterdrücken indem Sie den Divisionsvorgang innerhalb der Funktion WENNFEHLER schachteln.
To avoid DIV0. After all empty cells and zeros are valid entries. However I prefer to use the IF function.
However I prefer to use the IF function.
The above function gets text instead of numbers. However I prefer to use the IF function. Correcting div 0 error with IFERROR function If you want to get blank cells instead of div0 you can specify the formula with empty string at the end. Now we know in what are the scenarios we get this error now lets look at the ways of tackling this error in excel.