Accountancy Part CSpreadsheet

#NUM! Error - When does this error occurs in excel spreadsheet?

#NUM! Error - When does this error occurs in excel spreadsheet?

Answer & explanation

Correct answer: option 2

The correct answer is Option (2) → This error occurs with invalid numeric values in a formula or function.

Excel shows #NUM! when a formula or function gets a number it cannot work with, for example an argument that must be numeric is given something unacceptable, or a result is too large or too small to show. The other options describe different errors: an invalid cell reference gives #REF!, a value not available gives #N/A, and division by zero gives #DIV/0!.

NCERT (2026-27 edition):
#NUM! Error – “This error occurs with invalid numeric values in a formula or function.”