![]() The recorded formula in B1: =MATCH («Alex», A1:A4,0) searches for the text content «Alex» in the range of the cells A1:A4. The value is not available: #N/A! - means that the value is inaccessible to the formula: In the cell A3 is the square root can not be from a negative number, and the program displayed this result with the same error.It would seem that 1.000 is a small number, but when you return its factorial FACT(1000), a too large numerical value is obtained, which Excel can not cope. In the cell A2 – the same problem with large numbers.Excel can not work with such large numbers. There is to much number in the cell A1(10^1000).Also, this error can occur when trying to get a root from a negative number. The error: #NUM! occurs, when the numeric value is too large or too small. ![]() The wrong number: #NUM! – is the error of inability to perform the calculation in the formula. The result of the erroneous calculation is NUM ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |