Question

What does it mean when #DIV/0! is displayed and a green triangle is added to the upper-left corner of a cell?

Answer 1

the formula can be calculated but there is an error

Answer 2

Excel is unable to evaluate a worksheet formula or function

Step-by-step explanation

An error value such as #REF! , #NULL! ,#DIV/0! will be displayed in the cell where the formula is located. The Excel will display a small green triangle in the upper left corner of cell containing the error value to indicate that the cell’s content violates an Excel error checking rules.