Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > NA

 

NA()

 
 Returns the error value "#N/A".

 REMARKS
 
  • This is one of the few functions that does not require any arguments.
     
  • You must include the empty parentheses after the function name.
     
  • You can also type the value #N/A directly into a cell.
     
  • This function is provided for compatibility with other spreadsheet programs.

     EXAMPLES
     
     A
    1=NA() = #N/A
    2#N/A
     

     Functions - N | Index - N | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top