#NUM! Error in Excel
Four of the error messages are often talked in the course of Computer Operator or Secondary Level Computer Science.
#NAME! : Occurs when you make mistake in cell address or range name
#VALUE! : Occurs when you provide string where numeric data was required.
#DIV/0! : Happened to be divided by zero
####### : Formatted number does not fit within cell width
Today I am talking about #NUM! error in Excel
Cause:
- Unacceptable or invalid number is provided for numeric functions such as negative number for finding square root.
- Used a function that iterates and can not find a result
- If the result of formula or function is too large or too small.
To produce the error message in Excel, enter the function =sqrt(-16)
3 Responses to “#NUM! Error in Excel”
Tweets that mention #NUM! Error in ExcelICT Trends – Online Computer Jobs Exam Preparation | ICT Trends - Online Computer Jobs Exam Preparation -- Topsy.com on July 25, 2010
[...] This post was mentioned on Twitter by ICT Trends, Kannan B. Kannan B said: #NUM! Error in Excel: Four of the error messages are often talked in the course of Computer Operator or Secondary … http://bit.ly/aNyonM [...]
Opatija apartmani Hrvatska on July 26, 2010
I know many advanced features in excel. but, So far I know only one reason for this error in Excel. You have pointed out more reasons. Very educative blog man
Kim on January 2, 2011
I had this error on my older MS Excel and since now i am running Excel 2011, i didn't see it now. Great tips mate.