Excel Formulas

### How to Calculate Distance Between Two Cities in Excel

There are several uses for Excel. The cool special function and formula in Microsoft Excel may determine the separation between two specific cities ...

### How to Calculate Percentage Variance between Two Numbers in Excel

You can calculate the percentage variance between two numbers in multiple ways. The numbers can be either positive or negative. While calculating the ...

### How to Calculate Age Between Two Dates in Excel (6 Useful Methods)

Using several techniques in Excel, we may compute a person's actual age. We can use years, months, days, hours, and so on to compute the age. We must ...

### How to Use IF Function in Excel for Discounts (4 Suitable Examples)

The article will show you 3 genuine examples of how to use IF Function in Excel for discounts sales. If you are a businessman, you may offer ...

### How to Calculate Driving Distance between Two Addresses in Excel

Microsoft Excel is a very versatile spreadsheet program. It offers to do such a wide range of tasks that you can’t even imagine. You can even ...

### How to Calculate Pooled Variance in Excel (with Easy Steps)

In this article, we will show how to calculate pooled variance in Excel with easy steps using vivid illustrations. Download Practice Workbook ...

### How to Filter Dates by Month and Year in Excel (4 Easy Methods)

In this article, you will find some easy methods to filter dates by month and year in Excel. It is very common to filter dates by month or year as ...

### How to Use Nested IF Else in Excel Formula (4 Suitable Ways)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. We ...

### How to Insert Excel Timestamp When Cell Changes Without VBA (3 Ways)

In this article, we will learn to insert an Excel timestamp when a cell changes without VBA. A timestamp is a record of the time and date of a ...

### How to Calculate Average Price in Excel (7 Useful Methods)

We need to calculate the average price in various business sectors or in normal life frequently. Excel has made it easy to calculate the average ...

### How to Calculate Critical Z Score in Excel (3 Suitable Examples)

The article will show you how to calculate Critical Z Score in Excel. It’s an important parameter in the field of statistics. It tells us whether a ...

### How to Calculate 15% VAT in Excel (2 Useful Methods)

In many situations, you may need to calculate value-added tax or VAT. When you have a tool like Microsoft Excel, you can effortlessly perform such a ...

### How to Calculate Negative Margin in Excel (4 Easy Methods)

If you want to calculate negative margin in Excel, this article is for you. Here, we will walk you through 4 easy and effective methods to do the ...

### How to Use Nested IF and SUM Formula in Excel (2 Easy Methods)

While working with Microsoft Excel, sometimes we need to nest formulas. Nesting formulas in Excel is an easy task. This is a time-saving task also. ...

### How to Calculate Mileage Reimbursement in Excel (Step-by-Step Guide)

Mileage reimbursement calculation is one of the most common tasks in a business. You may also know mileage reimbursement as claim cost, or vehicle ...