over 5 years ago
The column which now shows #NUM! had values like 20000, 4000.
It earlier had values like mentioned above.
I copied a row, pasted it in another row and darn! It got messed up...
FYI- This sheet uses Tables.
You must have used a formula to calculate values in the cell that show the #NUM! error. Most probably the formula includes SQRT of a number and that number is a negative number. Square root of a negative number is not real, and probably because of that this error message shows.
Apurva, thanks. I have already seen that link but in vain.
Did you check whether you have turn on the error check on your excel , if yes then click (on error icon) next to cell which show the error. Click show calculation steps if available, and pluck the solution for your data.
for more you can take help from
there can be more than one reason for this error.
Check this link
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using