Information functions: na, type, isformula

Excel Function NA

The NA() function is used to display a '#N/A' error.

This error message means that, there is no value available.

This function is mostly used with automated excel sheets.

The excel will display this error message by default. When there is not any value that is being referred.

NA() Formula
#N/A =NA()

 

 

Excel Function TYPE

The TYPE() function is used to find the type of value supplied as argument.

The syntax of this function is as given below:

TYPE(Value)

TYPE() Formula
1 =TYPE(1)
2 =TYPE("TEXT")
64 =TYPE({1,45,6})
16 =TYPE(NA())
4 =TYPE(TRUE)

 

 

Excel Function ISFORMULA

The ISFORMULA() function is used to determine if a specified cell contains formula.

This function returns TRUE, if there is a formula and FALSE, otherwise.

This function is available from Excel 2013 onwards.

The syntax is as given below:

ISFORMULA(ref_cell)

Value ISFORMULA() Formula
2 True =ISFORMULA(L27)
2 False =ISFORMULA(L28)
0 True =ISFORMULA(L29)
#N/A False =ISFORMULA(L30)
Hello False =ISFORMULA(L31)

 

You can find similar Excel Questions and Answer hereunder

1) Excel 2010 vba replacement of application filesearch in Excel

2) Import txt file in Excel

3) How can I get the information about my current operating environment (OS version, Excel version, Current Directory)

4) How to freeze a row or column in Excel

5) Autofill a b c d aa ab in Excel

6) Vba to return week numbers in Excel

7) information functions isnontext isnumber isref istext n

8) how to combine the content of two or more cells in Excel

9) Find and count instances of a character in a string in Excel

10) Conditional formatting with if statement in Excel

 

Here the previous and next chapter