Free Online Tutorials on Spreadsheets

Information Functions in Excel

[vc_row][vc_column width=”1/2″][vc_column_text]

Numerical Information Functions

NConverts a value to a number, using pre-determined rules.
ISNUMBERChecks whether a cell has a number or text value.
ISODD Checks whether a cell’s data has odd or even numbers.
[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_column_text]

Other Data Type Functions

ISLOGICALTests whether a value is a logical or not.
ISTEXT Tests whether a value is a text or not.
ISBLANKChecks whether a cell is empty or not.
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column width=”1/2″][vc_column_text]

Error Information Functions

ISERRORChecks whether a value is an error or not.
[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_column_text]

General Information Functions

INFOReturns with information about the current operating environment like the number of active worksheets, excel file directory, operating system info and so on.
CELLReturns with cell’s information regarding formatting, location, and contents etc.
[/vc_column_text][/vc_column][/vc_row]




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved