What does it mean if excel is displayed as div/0? How to deal with it?
excel has the function of pulling down cells and copying formats, formulas, and contents. However, after copying formulas in drop-down cells, sometimes #DIV/0 will appear in the cell content! .
Recommended tutorial: excel tutorial
This happens because the content of the cell used in the copied formula is blank. As shown in the picture below, the formula I use is column E divided by column D, so when the contents of E6 and D6 are blank, this happens to F6.
At this time, you need to re-enter the formula, first enter [=if(and(].
Assume that D6 is Blank is represented as D60 in the formula, so continue to enter [=if(and(D60]] in the formula.
The same principle , assuming that E6 is a blank cell, the formula is [=if(and(D60,E60)], separated by English commas in the middle of the formula, the AND condition ends here, enter a right Parentheses.
Then separate them with commas, and then enter the copied original formula [E6/D6]. Then enter double quotes. There is no need for anything inside the double quotes. , that is, [if(and(E60,D60),E6/D6,""]. No content is entered in the double quotes. When E6 and D6 are zero, the cell will not display any content. , if you want to display it as 0, you can enter 0 inside the double quotes.
Then enter the double quotes. There is no need for anything in the double quotes, and then add a right bracket , so the complete formula is [if(and(E60,D60),E6/D6,"")]. No content is entered in the double quotes. When E6 and D6 are zero, the cell No content will be displayed. If you want to display 0, you can enter 0 inside the double quotes.
Enter key to confirm the formula, and cell F6 will not display any content. Got it.
The above is the detailed content of What does it mean if excel displays div/0?. For more information, please follow other related articles on the PHP Chinese website!