The ISNA function returns TRUE when a cell contains the #N/A error and FALSE for any other value, or any other error type. The ISNA function takes one argument, value, which is typically a cell reference.
If A1 contains the #N/A error, ISNA returns TRUE:...Read more
The ISLOGICAL function returns TRUE when a cell contains the logical values TRUE or FALSE, and returns FALSE for cells that contain any other value, including empty cells.
The ISLOGICAL function takes one argument, value, which can be a cell reference, a formula, or a hardcoded...Read more
The ISBLANK function is a simple function to test if a cell is empty or not. If a cell is empty, ISBLANK returns TRUE. If a cell contains any value, ISBLANK returns FALSE. ISBLANK function takes one argument, value, which is a cell reference like A1. For example, if cell...Read more
The Excel ERROR.TYPE function returns a number that corresponds to a specific error value. You can use ERROR.TYPE to test for specific kinds of errors. If no error exists, ERROR.TYPE returns #N/A. See the table below for a key to the error codes returned by ERROR....Read more
Use the CELL function to return a wide range of information about a reference. The type of information returned is given as info_type, which must be enclosed in double quotes (""). CELL can return a cell's address, the filename and path for...Read more
The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells or a horizontal range of cells to a vertical range of cells. In other words, TRANSPOSE "flips" the orientation of a given range or array:
The Excel OFFSET function returns a dynamic range constructed with five inputs: (1) a starting point, (2) a row offset, (3) a column offset, (4) a height in rows, (5) a width in columns.
OFFSET is a volatile function
...Read more
