Excel Spreadsheets Functions: Information

    

613-749-4695
[email protected]

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

 

This page is offered to you as reference
You will probably use only 24% of  these Excel spreadsheet functions

Click here for more on the interesting Excel spreadsheets functions of information  category

 

Excel Lesson 24E of 24: Excel Spreadsheets  Information Functions (17)

Here is the list of the functions of the information  category. Of the 17 functions of the lookup and reference category 4 are interesting and useful. Follow the links below to discover formulas using them.

Importance Functions What it Does
Interesting CELL  Returns information about the formatting, location, or contents of a cell
Essential ISERROR Returns TRUE if the value is any error value
Interesting ISNUMBER Returns TRUE if the value is a number
Interesting ISTEXT Returns TRUE if the value is text

Rarely Used

ERROR.TYPE Returns a number corresponding to an error type

Rarely Used

INFO Returns information about the current operating environment

Rarely Used

ISBLANK  Returns TRUE if the value is BLANK

Rarely Used

ISERR Returns TRUE if the value is any error value except #N/A

Rarely Used

ISEVEN Returns TRUE if the number is even

Rarely Used

ISLOGICAL Returns TRUE if the value is a logical value

Rarely Used

ISNONTEXT Returns TRUE if the value is not text

Rarely Used

ISNA Returns TRUE if the value is the #N/A error value

Rarely Used

ISODD Returns TRUE if the value is odd

Rarely Used

ISREF Returns TRUE if the value is a reference

Rarely Used

N Returns a value converted to a number

Rarely Used

NA  Returns the error value #N/A

Rarely Used

TYPE Returns a number indicating the data type of a value

Back to All Functions

 

Next Chapter: Logical Functions in Excel

Excel Table of Contents
or use the quick links below

 

Discover Even More in 50 Excel spreadsheets

 

    

613-749-4695
[email protected]com

Home Page

Tips and Ideas on Excel
Table of Contents on Excel

Tips and Ideas on Macros
Table of Contents on VBA

Quick Links

Excel Spreadsheets Functions: Information