Excel NA Function

What is NA function in Excel?

The NA function is one of the Information functions of Excel.

It Returns the error value =NA (value not available).

We can find this function in Information of insert function Tab.

How to use NA function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Information category.

5. Select NA function

6. Then select ok.

excel NA function

7. In the function arguments Tab you will see NA function.

8. This function takes no arguments.

How to use NA function in excel

NA related functions

  • Use N function to Converts non-number values to a number, dates to serial numbers, TRUE to 1, and anything else to 0.
  • Use ISNA function to check whether a value is=N/A and returns TRUE or FALSE.
  • Use ISERR function to check whether a value is an error and returns TRUE or FALSE.
  • Use ISERROR function to check whether a value is an error, and returns TRUE or FALSE.

Leave a Reply

Your email address will not be published. Required fields are marked *