All resources related to INFORMATION for Excel and Google Sheets.

All articles
INFORMATION

Excel INFO Function

Excel INFO function returns information regarding the existing environment: spreadsheet number, workbook number, and platform. However, there are several requirements that need to be provided as below: Syntax =INFO(type_text) Explanation The INFO function easily recovers data of the existing environment such as OS version, OS, and Excel versions. You need...

Excel INFO Function

While working on a spreadsheet, excel info function provides information regarding the existing environment. For example, spreadsheet number in workbooks, platforms, and much more. You need to provide the relevant information for using INFO function. Syntax The formula of excel info function is given below =INFO (type_text) Explanation Excel info...

Excel ISERROR Function

We can use the ISERROR function to test if a cell contains any kind of error message such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!. The simple steps below will walk through the process. Figure 1- Final result of the ISERROR function Syntax =ISERROR(value) Formula =ISERROR(B5) Setting up...

Excel ISODD Function

We can use the Excel ISODD function to test whether an imputed numerical value is an odd number. This article will walk through the simple steps. Figure 1 – How to Use the Excel ISODD function General Formula =ISODD(value) “Value” is the numerical value we want to test if it...

Excel ISNA Function

Figure 1. of Excel ISNA Function. The purpose of the Excel ISNA Function is to return a TRUE value whenever a cell in our worksheet has a #N/A error as well as return a FALSE value for any other type of error. This step by step tutorial will walk through...

Excel ISEVEN Function

If we want to find if a value in a cell is even or odd, we can use the excel ISEVEN function. This function returns TRUE when the numeric value is even, and FALSE if it is odd. This post provides a clear guide on how to use the excel...

Excel SHEETS Function

We can use the Excel SHEET function to get the index number of a given sheet in excel. This function reports the sheet number for the cell reference, named range or the excel table. To understand how this function works, read this post to the end. Figure 1: Using Excel...

Excel ISBLANK Function

When we want to know whether cells in an excel spreadsheet are empty or not, we can use the excel ISBLANK function. This function returns TRUE if the cell is empty, and FALSE if not empty. This post provides a clear guide on how to use the Excel ISBLANK function....

Excel ERROR.TYPE Function

The ERROR.TYPE function in Excel returns a number that corresponds to a specific error value, which is particularly useful when used in combination with other functions. This step by step tutorial will assist all levels of Excel users in the usage and syntax of ERROR.TYPE function. Figure 1. Final result:...

Excel ISNONTEXT function

While working with Excel, it is fairly easy to determine if a value is not text by using the ISNONTEXT function. ISNONTEXT belongs to the IS functions, which returns logical values TRUE or FALSE. This step by step tutorial will assist all levels of Excel users in the usage and...