# Excel Formulas

## Collection by Excel Tutorial

Learn Excel formulas and functions in this thread, you will get to know about each and every excel formulas of Office 365 or later. This board will be updating every day with new excel formulas and its uses. Follow this board to get to know each and every formulas.

### Get number of hours between two times - Excel Tutorials

If you have two timings⏳ in your screen and you want to calculate the difference between them or in other words you want to calculate...

### Get Month from date Using MONTH Formula - Excel Tutorials

When you have a bunch of dates and all you need is to get the month out of it, here’s what you can do:

### Find out if a cell is THIS or THAT Using IF & OR Formula - Excel Tutorials

When you want to find a particular data, which has some sort of specifications but you have loads and loads of data in your hand so it becomes kind of difficult, you have come to the right place.

### Find Cube Root of number in Excel - Excel Tutorials

When you are weak in math, even a cube root becomes a huge deal🙅! So, to find out the cube root🤓 of a number in...

### Convert feet and inches to inches In Excel - Excel Tutorials

If you are looking for a way where you could convert feet and inches into inches through excel, you have come up in the right...

### Calculate the total number of rows in a range with ROWS Formula - Excel Tutorials

To calculate the total number of rows in a range, here’s what we can do:

### How to calculate the percentage variance quickly? - Excel Tutorials

To calculate the percentage variance in excel, let’s take an example for the same.

### How to count data that ends with a particular value? - Excel Tutorials

In this space, we will learn how to count data that ends with a particular value e.g. RSVPUP-12-P, here, P is the ending value of...

### How to count unique values in a range? - Excel Tutorials

If you want to count the unique values in a range, you can do the same with the help of SUMPRODUCT Function and COUNTIF Function.

### How to group numbers at uneven intervals using VLOOKUP? - Excel Tutorials

When you are dealing with thousands of data entries, you prefer to have a systematic order😬 in the same. This can be done in one simple way, adding things into groups. This will make the data look more organised📚.

### How to override output from VLOOKUP? - Excel Tutorials

When you have a proper detailed or systematic requirement regarding some data, this how you can categorize the same🤓🤔: The example above will give you...

### How to show formula text with FORMULATEXT Function? - Excel Tutorials

If you want to check on the formula or the function that you used over a data, you can use another function i.e. FORMULATEXT Function.

### How to sum data by weekday in excel? - Excel Tutorials

If you want to calculate the sum total of your earnings or expenditure or anything like that in reference to the weekday, here’s what you can do:

### Pad text to equal length In Excel - Excel Tutorials

Pad text to equal length: When we are dealing with loads of cells which have data filled in it, we observe that due to the length of different data’s (or characters together) they seem very inappropriate.

### How to use VLOOKUP with multiple criteria in excel? - Excel Tutorials

VLOOKUP is very handy When you have a particular data in hand, and you need to find something in relation to it, it becomes nearly...

### How to use RANK Formula? - Excel Tutorials

As you can tell from the topic itself, this is about RANK Function only. Ranking is an aspect which is very important for a person...