explain different type of formula error
Answers
Answered by
2
Answer:
Ur answer is in the img form......
Attachments:
Answered by
2
Answer:
◾ error appears when a formula tries to divide by zero, or by a value equivalent to zero. You may see a #DIV/0! error when data is not yet complete. For example, a cell in the worksheet is blank because data has not been entered, or is not yet available.
◾ #NULL! ✒ You specified an intersection of two cell ranges whose cells don't actually intersect
◾ #NUM! ✒ Problem with a number in the formula
◾ #REF! ✒ Invalid cell reference
◾ #VALUE! ✒ Wrong type of argument in a function or wrong type of operator
Hope it helps u dear...❤❤❤
Similar questions
Math,
2 months ago
Political Science,
2 months ago
English,
2 months ago
Physics,
5 months ago
Social Sciences,
5 months ago
Social Sciences,
11 months ago
Social Sciences,
11 months ago