Some of the more common Error messages in Excel 2013 are; #REF! – Occurs when a formula contains incorrect cell references. Common causes include moving data that is used within a formula, or moving a formula making the cell references incorrect. #VALUE! – Occurs when the wrong type of argument is used. Common causes include entering text when the formula requires a number, or entering a range on cells when the formula requires a single cell reference #NAME? – Occurs when Excel does not recognise text in a formula. Common causes include misspelling a range name, or referring to text in a formula and not enclosing it in double quotation marks. #N/A – Occurs when a value is not available to a formula. Common causes include using the VLOOKUP function to search for a value that is not included in a table, or located in an unsorted table.
http://www.writeawriting.com/ms-office/excel-2013-formula-errors-understanding-troubleshooting/
No comments:
Post a Comment