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

if a bag contains 2 red marbles, 3 blue marbles, 5 yellow marbles and 2 green marbles, if a marble is randomly selected what is the probability that it is red _
How do totalitarian states and constitutional governments differ?
How was Spanish colonial society structured?
Legislative Branch - Define expressed powers.
What did the case Plessey v. Ferguson decide?
To vary the sentence structure, which one of the answer choices should you insert into the blank space? Anna is an exceptional young girl. _______ Anna does any
What were some of the effects of King Solomon’s reign?
A group of 32 players forms 4 volleyball teams. If there are 96 players, how many teams can be formed?
if 35% is 70 what is 100%
Which form of curly best completes this sentence? Among the girls at our family reunion, Esther had the __________ hair of all. A. curliest B. curlier C. more c