Question

Give the description of the following two errors in Excel:

1. # NULL
2. # NUM

Answer 1

1. #NULL! Error: This error occurs when a formula uses an incorrect range operator or when Excel does not understand the relationship between the ranges specified in the formula.
2. #NUM! Error: This error occurs when a formula contains invalid numeric values, such as trying to calculate the square root of a negative number or using a number that is too large or too small for Excel to process.