Page 246 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

If we notice the cells D6 and D8, we get an error as #VALUE!. The reason we got #VALUE! Error because there
is no commission percentage in the cells C6 and C8.
We cannot multiply the text value with numerical values.
How to Fix the #VALUE! ERROR Issue?
In these cases, we must replace all the text values with zero until we get further information.
#6 ###### Error

The ###### error, is not an error. Rather, it is just a formatting issue. For example, look at the below image in cell
A1 that has entered the date values.

It is due to the length issue of the characters. The values in the cell are more than the column width. In simple
terms, the column width is not wide enough.

How to Fix the ###### ERROR Issue?
We must double-click on the column to adjust the column width to get the full values visible.

#7 #N/A! Error
The #N/A! error is because the formula cannot find the value in the data. It usually occurs when the Excel lookup
functions like VLOOKUP, HLOOKUP, MATCH, and VLOOKUP cannot find the value you are looking for within the
formula in the specified range.

233

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