Excel Formulas Archives - Page 57 of 149

How to Reverse Score in Excel (4 Easy Ways)

Jul 5, 2024

Method 1 - Subtracting Original Score to Reverse Score Step 1: Find the highest value from the original score. In our example, the highest ...

How to Reverse Score in Excel (4 Easy Ways)

How to Find Repeated Cells in Excel: 4 Easy Methods

Jul 5, 2024

Method 1 - Applying Excel Conditional Formatting to Find Repeated Cells Steps: Select the range B5:D14 and go to Home >> Conditional ...

How to Find Repeated Cells in Excel: 4 Easy Methods

How to Calculate the Total Score in Excel – 4 Easy Methods

May 9, 2024

The following is the sample dataset. Method 1 - Using the SUM Function Step 1: Select the cell in which you want to see ...

How to Calculate the Total Score in Excel – 4 Easy Methods

How to Calculate Cost of Debt in Excel (3 Simple Ways)

Nov 11, 2025

Debt financing and equity financing are two important types of financing. Any business that wants to operate must obtain loans from a variety of ...

How to Calculate Cost of Debt in Excel (3 Simple Ways)

How to Make Automatic Marksheet in Excel (with Easy Steps)

Jul 6, 2024

Sheet1 contains the personal details, numbers, and grading of each student. Sheet2 contains the mark sheet template. We inserted a bold ...

How to Make Automatic Marksheet in Excel (with Easy Steps)

How to Compute Grades in Excel (3 Ways)

Apr 27, 2024

In this sample dataset the columns are labelled Name, Marks, and Grades. For the grades, we have 5 possible options. Method 1 - ...

How to Calculate Grades with Weighted Percentages in Excel

Nov 11, 2025

Sometimes professors give more weight to a certain exam or quiz which means those exams contribute some value than other exams. In that case, the ...

How to Calculate Grades with Weighted Percentages in Excel

How to Calculate Current Portion Of Long Term Debt in Excel

Aug 4, 2024

What Is the Current Portion of Long-Term Debt? The Current Portion of Long-Term Debt is the amount of a company's long-term debt that is due within ...

How to Calculate Current Portion Of Long Term Debt in Excel

How to Create a Balanced Scorecard in Excel (with Detailed Steps)

Jun 17, 2024

Watch Video – Create a Balanced Scorecard in Excel Step 1 - Assign Factors for the Scorecard Model Assign the parameters which will ...

How to Create a Balanced Scorecard in Excel (with Detailed Steps)

How to Compare Two Tables in Excel Using VLOOKUP Function

Nov 11, 2025

If we need to compare two tables in Excel, we can use the VLOOKUP function. It’s an easy way to compare two tables and find missing values, common ...

How to Compare Two Tables in Excel Using VLOOKUP Function

Calculate Grade Using IF function in Excel (with Easy Steps)

Jun 14, 2024

Download the Practice Workbook Calculate Grade Using IF function.xlsx 4 Simple Steps to Calculate a Grade Using the IF Function in Excel ...

Calculate Grade Using IF function in Excel (with Easy Steps)

Excel Formula for Pass or Fail with Color (5 Suitable Examples)

Nov 26, 2023

Most of the time for educational purposes, you may need to use Excel Formula for Pass or Fail with Color. In this article, I will demonstrate how to ...