WHAT IS THE ERROR MESSAGE DISPLAYED WHEN A FORMULA IN MS-EXCEL CONTAINS INVALID DATA
#REF
#DATA
#VALUE
#N/A
Share
WHAT IS THE ERROR MESSAGE DISPLAYED WHEN A FORMULA IN MS-EXCEL CONTAINS INVALID DATA
#REF
#DATA
#VALUE
#N/A
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
The #N/A Excel formula error is produced when a value is not available to your formula. For example, the example below shows an attempt to use the Vlookup function to find the value "Cabbage" in column C of the spreadsheet, and return the associated cost from column D.