Home Excel Formulas

Excel Formulas

How to combine multiple cells into one cell

The Excel CONCATENATE function is a part of TEXT family and used for merging two or more text string into one string. The most commonly...

How to use FIND Function in Microsoft Excel

The Excel FIND function returns the position of a character or sub-string within a supplied text string. Function returns output only in number form...

How to use Excel New IFS Function

In this tutorial, you’ll learn about newly introduced Excel IFS function that can be used as an alternative to the nested IF statements. You...

How to use Excel Day Function

This article explains the syntax and the use of Excel DAY function in Excel. The Excel DAY function returns the day of the month from...

How to use ROUND function in Microsoft Excel

This tutorial illustrates the syntax and examples of Excel ROUND function. You will also learn how to use this function on the real-life data. The...

How to use Excel INT Function (Examples + Videos)

The Excel INT function rounds a number down to the nearest integer value. It simply returns the integer portion of a decimal number. Uses: You can...

Randbetween Function in Microsoft Excel

Use RANDBETWEEN function to create random number between two numbers (bottom and top). Whenever we work on worksheet it calculates for new number every time....

How to use Vlookup Function in Microsoft Excel

In this article, you will see the exciting and interesting use of one of the powerful Excel VLOOKUP function. The article covers real life...

How to use Excel EDATE Function

This article explains the syntax and the use of the EDATE function in Microsoft Excel. The Excel EDATE function returns the serial number that represents...

How to use RIGHT function in Microsoft Excel

The Excel RIGHT function returns one or more character, based on the specified number of characters from the end of a supplied text string. Syntax: =RIGHT(text,...