0,D6<>0),E6/D6,"")" is enough."/> 0,D6<>0),E6/D6,"")" is enough.">

Home  >  Article  >  Topics  >  What does it mean if excel displays div/0?

What does it mean if excel displays div/0?

藏色散人
藏色散人Original
2020-02-08 09:22:0715861browse

What does it mean if excel displays div/0?

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

What does it mean if excel displays div/0?

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.

What does it mean if excel displays div/0?

At this time, you need to re-enter the formula, first enter [=if(and(].

What does it mean if excel displays div/0?

Assume that D6 is Blank is represented as D60 in the formula, so continue to enter [=if(and(D60]] in the formula.

What does it mean if excel displays div/0?

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.

What does it mean if excel displays div/0?

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.

What does it mean if excel displays div/0?

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.

What does it mean if excel displays div/0?

Enter key to confirm the formula, and cell F6 will not display any content. Got it.

What does it mean if excel displays div/0?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:What does excel sum mean?Next article:What does excel sum mean?