INFORMATION Articles: Excel and Google Sheets

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...

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...

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...

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...

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...

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...

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...

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....

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:...

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...