Formula List in Excel Archives

Calculate Salary in Excel

Feb 10, 2024

Calculate Salary in Excel: Knowledge Hub Calculate Basic Salary in Excel Calculate Gross Salary in Excel Calculate Net Salary in Excel ...

How to Create a Scoring Formula in Excel (System, Text, Grade, Z Score)

Jun 28, 2024

Scoring formulas in Excel are valuable for ranking and evaluating datasets. They allow us to calculate scores efficiently, consider weights, rewards, ...

How to Create a Scoring Formula in Excel (System, Text, Grade, Z Score)

Excel Sales Formula: All You Need to Know

Jul 7, 2024

In this article, we will explore several important Excel Sales formulas that can greatly improve your sales analysis and help you to find valuable ...

Excel Sales Formula: All You Need to Know

Excel If Time Between Range (4 Quick Ways)

May 29, 2024

Finding out if time is between range is used to make decisions for attendance tracking, event scheduling, project monitoring tasks, employee shift ...

Excel If Time Between Range (4 Quick Ways)

Distance Formula in Excel (4 Examples to Calculate)

Dec 31, 2023

In this article, we will learn how to find distance using formulas in Excel. We will apply the basic arithmetic formula, the Euclidean formula, the ...

Distance Formula in Excel (4 Examples to Calculate)

How to Calculate BMI with Formula in Excel: 3 Methods

Jul 5, 2024

Method 1 - Calculate BMI in Metric Unit Select cell E5 and type the following formula: =D5/C5^2 D5 is the weight, and C5 is a person's height. ...

How to Calculate BMI with Formula in Excel: 3 Methods

Leave Calculation Formula in Excel (5 Leave Types)

May 16, 2024

Say you have a dataset containing working hours and leave types of an employee. You want to calculate half-day, casual, and ...

Leave Calculation Formula in Excel (5 Leave Types)

Ageing Formula in Excel (All Things You Need to Know)

Jul 6, 2024

Download Practice Workbook Ageing Formula.xlsx Method 1 - Calculate Age in Years We can use the combination of several functions ...

Ageing Formula in Excel (All Things You Need to Know)

How to Count Number of Columns in Excel: 5 Methods

May 21, 2024

Method 1 - Using Status Bar to Count Number of Columns in Excel Select the headers of the chart or dataset (or a particular row, which doesn’t ...

How to Count Number of Columns in Excel: 5 Methods

How to Calculate Discount in Excel (2 Easy Methods)

May 9, 2024

Method 1 - Creating an Excel Formula to Calculate a Discount Price Suppose we have a dataset of a Mobile selling shop with their product ...

How to Calculate Discount in Excel (2 Easy Methods)

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

May 12, 2024

This is an overview. ⏷The Basics of INDEX and MATCH Functions ⏵The INDEX Function ⏵The MATCH Function ⏷How to Use Combination ...

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

How to Count Rows with a Formula in Excel (5 Methods)

May 26, 2024

Method 1 - Using the ROWS Function to Count Rows in Excel Steps: Enter the below formula in Cell D12: =ROWS(B5:D10) Here, ...

How to Count Rows with a Formula in Excel (5 Methods)

How to Timesheet Formula in Excel: 5 Methods

May 28, 2024

Method 1 - Excel Timesheet Formula: Using Simple Subtraction Apply the simple arithmetic subtraction formula within this Excel timesheet. To do ...