DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
N / A #
|
|
|
DIV / 0 #
|
|
|
! REF #
|
|
|
VALUE #
|
Detailed explanation-1: -If ### is displayed because Excel can’t display all of the characters this will correct it. Excel displays this error when a number is divided either by zero (0) or by a cell that contains no value. Excel displays this error when a value is not available to a function or formula.
Detailed explanation-2: -The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data. In this case there is no “Banana” listed in the lookup table, so VLOOKUP returns a #N/A error.
Detailed explanation-3: -Solution: Shorten the value, or use a combination of INDEX and MATCH functions as a workaround. This is an array formula. So either press ENTER (only if you have Microsoft 365) or CTRL+SHIFT+ENTER.
Detailed explanation-4: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.