Information functions provide information about errors , numbers , and cells in the excel spreadsheet .
Information function in MS Excel
There are total 20 functions in MS Excel . These functions are given below :
1.) CELL : Returns information about the formatting , location , or contents of the first cell , according to the sheet's reading order , in a reference .
2.) ERROR.TYPE : Returns a number matching an error value .
3.) INFO : Returns information about the current operating environment .
4.) ISBLANK : Checks whether a reference is to an empty cell , and returns TRUE or FALSE .
5.) ISERR : Checks whether a value is an error ( #VALUE!, #REF!,#DIV/0!,#NUM!,#NAME? ,or #NULL!) excluding #N/A, and returns TRUE or FALSE .
6.) ISERROR :Checks whether a value is an error (#N/A, #VALUE!, #REF! , #DIV/0!, #NUM!, #NAME?, or #NULL!),and returns TRUE or FALSE .
7.) ISEVEN : Returns TRUE if the number is even .
8.) ISFORMULA : Checks whether a reference is to a cell containing a formula , and returns TRUE or FALSE .
9.) ISLOGICAL : Checks whether a value is a logical value ( TRUE or FALSE ) , and returns TRUE or FALSE .
10.) ISNA : Checks whether a value is #N/A, and returns TRUE or FALSE .
11.) ISNONTEXT : Checks whether a value is not text ( blank cells are not text ), and returns TRUE or FALSE .
12.) ISNUMBER : Checks whether a value is a number , and returns TRUE or FALSE .
13.) ISODD : Returns TRUE if the number is odd .
14.) ISREF : Checks whether a value is a reference , and returns TRUE or FALSE .
15.) ISTEXT : Checks whether a value is text , and returns TRUE or FALSE .
16.) N : Converts non-number value to a number , dates to serial numbers , TRUE to 1 , anything else to 0 (zero) .
17.) NA : Returns the error value #N/A ( value not available ) . This function takes no arguments .
18.) SHEET : Returns the sheet number of the referenced sheet .
19.) SHEETS : Returns the number of sheets ina reference .
20.) TYPE : Returns an integer representing the data type of a value : number = 1 ; text = 2 ; logical value = 4 ; error value = 16 ; array = 64 .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=INFORMATION FUNCTIONS IN MS EXCEL ){kind=link}
0 Comments