afox1 afox1
  • 24-12-2017
  • Computers and Technology
contestada

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

Respuesta :

hogano hogano
  • 28-12-2017
the formula can be calculated but there is an error
Answer Link
lucic
lucic lucic
  • 12-11-2018

Answer

Excel is unable to evaluate a worksheet formula or function

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.


Answer Link

Otras preguntas

Which of the following is a solution to the equation 4x2+4x−3=0? -1.5 -0.5 1 3
Write an essay about health is wealthat least 300 words​
imagine that you drop a ball . It bounces a few times , but then stops . Your friend says that the ball has lost all of its energy . Using what you know about t
use distributive property then solve for y: 2(8 + y) = 22
In a Healthy Jogging event, a few hundred participants were expected to jog 3 500 000 metres altogether. They had jogged 65 000 metres in the first few minutes.
Given the list of functions. calculate each of the following F(x)=x-2 g(x)=-3x + 2 h(x)=1/5x -6 Find g(-2) A. g(-1) =6 B. g(-1)=-6 C. g(-1) =8 D. g(-1)=-8
Please can someone help me
help, please the question and thank you
Help Please help now
On a 1-75 bingo board how many numbers have a 3 in it