What does #NUM! mean?
There is no real number that answers the question. Sometimes that is the answer: two lines that never meet, or a ball that never gets high enough.
#NUM!There is no real number that answers the question. Sometimes that is the answer: two lines that never meet, or a ball that never gets high enough.
Check the inputs that feed a square root or logarithm.
What’s this?Common causes
- Square root of a negative number
- Logarithm of zero or a negative number
- A quadratic with no real roots
- Parallel lines that never intersect
- A number too big to represent
How to fix it
- Check the inputs that feed a square root or logarithm.
- If the lines are parallel, change one slope.
In spreadsheets
Same as #NUM! in spreadsheets.