Tag Archives: #div/0

Four of the error mes­sages are often talked in the course of Com­puter Oper­a­tor or Sec­ondary Level Com­puter Science.

#NAME! : Occurs when you make mis­take in cell address or range name

#VALUE! : Occurs when you pro­vide string where numeric data was required.

#DIV/0! : Hap­pened to be divided by zero

####### : For­mat­ted num­ber does not fit within cell width

Today I am talk­ing about #NUM! error in Excel

Cause:

• Unac­cept­able or invalid num­ber is pro­vided for numeric func­tions such as neg­a­tive num­ber for find­ing square root.
• Used a func­tion that iter­ates and can not find a result
• If

…