Question

Name the error which occurs when Excel doesn't recognize a Text formula. Give any two solutions to correct it.

Hint:

The \#NAME? error in Excel almost always points to something Excel doesn't recognize in the text part of your formula. Check for:
1. Typos in function names (e.g., `VLOKUP` instead of `VLOOKUP`).
2. Text strings used without double quotes (e.g., `Pass` instead of `"Pass"`).
3. Incorrectly spelled or undefined Named Ranges.

Answer 1

Error Name:
The error that occurs when Excel does not recognize text in a formula is typically the \#NAME? error.
Causes and Solutions:
The \#NAME? error usually appears due to:
1. Misspelled Function Name or Text String: Excel cannot find a function or defined name matching the text entered.
* Solution 1: Correct the spelling of the function name (e.g., change `SUMM` to `SUM`) or the named range. Ensure any text strings used within the formula (that aren't defined names) are enclosed in double quotation marks (e.g., use `"Total"` instead of `Total` if 'Total' is just text).
2. Using Text Without Quotation Marks: Attempting to use a text string directly in a formula without enclosing it in double quotes (unless it's a defined name).
* Solution 2: Enclose the intended text string in double quotation marks (e.g., `=IF(A1>10,"Pass","Fail")` instead of `=IF(A1>10,Pass,Fail)`). If the text is supposed to be a named range or defined name, ensure the name has been correctly defined in Excel's Name Manager and is spelled correctly in the formula.
(Other less common causes: Function not available in the Excel version, Add-in providing the function not enabled).