Excel Formulas Archives - Page 5 of 106

How to Calculate Distance Between Two Cities in Excel

Jun 20, 2022 Excel Formulas

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

Jun 19, 2022 Excel Formulas

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)

Jun 26, 2022 Excel Formulas

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)

Jun 20, 2022 Excel Formulas

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

Jun 20, 2022 Excel Formulas

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)

Jun 18, 2022 Excel Formulas

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)

Jun 17, 2022 Excel Formulas

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)

Jun 19, 2022 Excel Formulas

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)

Jun 23, 2022 Excel Formulas

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)

Jun 16, 2022 Excel Formulas

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)

Jun 16, 2022 Excel Formulas

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)

Jun 19, 2022 Excel Formulas

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)

Jun 16, 2022 Excel Formulas

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)

Jun 19, 2022 Excel Formulas

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)

Jun 16, 2022 Excel Formulas

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