Information Functions in Excel

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.

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.

Error Information Functions

ISERRORChecks whether a value is an error or not.

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.
Copyright © 2016 - 2018 Explainry.com | All Rights Reserved