Function

Count the Number of Characters in a Cell – Excel LEN Function

In this tutorial, we will learn about Excel LEN Function, basically, we use this function to count the length of the cell string or value. This function counts every single character including a single space too. Why we use this?   Excel LEN function is very useful to count or find the length of the …

How to Use Excel SUBTOTAL Function – A Detailed Guide

In this tutorial, we will learn about Excel SUBTOTAL Function. This is one of the powerful, easiest and most useful function in Excel. This function increases the usability of some basic functions. What is SUBTOTAL Function in Excel?   The SUBTOTAL is a most useful and versatile function in Excel. This function works dynamically in a …

How to use Excel ISNA Function – An introduction

Excel ISNA Function reads the cell value if it is an error code #N/A then it will return as TRUE otherwise FALSE.

How to use Excel ISERR Function – An Introduction

Excel ISERR Function checks the value in a cell, apart from #N/A, if a cell has any of the following errors like – #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? and #NULL!, it will return TRUE otherwise FALSE. This function is a member of IS group of functions in Microsoft Excel. Why we use Excel ISERR Function? …

How to use Excel ISNONTEXT Function – An introduction

Excel ISNONTEXT Function is a logical operator and returns TRUE or FALSE as a result. This function returns TRUE for values like – date, number, time, etc. and returns FALSE for all text values. Excel ISNONTEXT is a member of IS group of functions in Microsoft Excel. Why we use this?   This function test a cell …

How to use Excel ISREF Function – An introduction

Excel ISREF Function is a member of IS function in Microsoft Excel. This function checks, if cell value refers to another cell. If refer, it returns as TRUE and if not then FALSE. What is the syntax for ISREF?   =ISREF (value) Syntax Explained   Value (required) – cell value to be checked for a …

How to use Excel RIGHT function with example

Excel RIGHT function In this blog post, we will learn about Excel RIGHT function. What is Excel RIGHT Function and how can we use this function in our working routine. This function is very similar to Excel LEFT function. The only difference is the Excel LEFT Function retrieves the data from the left side of …

How to use Excel LEFT Function with example

In this blog post, we will learn about Excel LEFT function. What is Excel LEFT Function and how can we use this function in our working routine? Define Excel LEFT function “Excel LEFT function helps us to retrieve some specific numbers of characters from the given string in a cell.” Excel LEFT Function   …

What does the ISLOGICAL function do in Excel?

ISLOGICAL function check for a logical (TRUE/FALSE) value in a cell. If the cell contains a logical (TRUE/FALSE) value, it will return TRUE otherwise it will return FALSE. ISLOGICAL function in Excel The ISLOGICAL function in a built-in function of “IS-family” in Excel and gives a Boolean (TRUE/FALSE) result. If the cell value is …

What does the ISBLANK function do in Excel?

ISBLANK function in Excel The ISBLANK function is a built-in function of “IS- family” in Excel and gives a Boolean (TRUE/FALSE) result. If a cell is blank, it will return TRUE otherwise return FALSE. Syntax of the function =ISBLANK (value) Arguments of the function Value – where the value is a cell status to check. …