Page 245 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

We must always undo the action if we accidentally delete any rows, columns, or cells.
#4 #NULL! Error
The #NULL! Error is due to the wrong value supplied to the required parameters; for example, after the improper
supply of range operator, incorrect mention of parameter separator.
Look at the below image. We have applied the SUM formula to calculate the sum of the values in cells A2 and B2.
The mistake we made here is after the first argument. We should give a comma (,) to separate the two arguments.
Instead, we have provided space.

How to Fix the #NULL! ERROR Issue?
In these cases, we need to mention the exact argument separators. For example, we should use the comma (,)
after the first argument in the above image.

In the case of a range, we need to use a colon (:).

#5 #VALUE! Error

The #VALUE! error occurs if the formula cannot find the specified result. It is due to non-numerical values or
wrong data types to the argument.
Look at the image below. We have calculated the commission amount based on the sales value and commissions.

232

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77