How to remove errors in Excel cells?

Question

excel

Hello. There are formula errors that contain cells. #LINK! #NUMBER! etc!
I roughly understand the meaning of the errors, but how to fix them?

Answer 1

The question is not entirely clear.
#LINK! - appears if you have deleted the cell (or other entire file) referred to by this formula. Accordingly, take and correct the link to the correct cell.
#NUMBER! - appears when it is impossible to perform mathematical calculations, for example, when trying to take the square root of a negative number

Answer 2

Error: #NUMBER! occurs when a numeric value is too large or too small. Also, this error can occur when trying to get the root of a negative number. For example, =ROOT(-25).
In cell A1, the number is too large (10^1000). Excel cannot work with such large numbers.
Cell A2 has the same problem with large numbers. It would seem that 1000 is a small number, but when you return its factorial, it turns out to be too large a numeric value that Excel cannot handle.
In cell A3, the square root cannot be from a negative number, and the program displayed this result with the same error.
Alternative verification method where you can recover xlsx online