Excel Formulas Archives - Page 58 of 149

How to Convert Decimal to Time in Excel Using Formula

Jul 3, 2024

Excel by default stores time in decimal format. This tutorial will demonstrate how to convert decimal format to time format in Excel using formulas. ...

How to Convert Decimal to Time in Excel Using Formula

How to Repeat Rows in Excel at Bottom: 5 Easy Methods

May 25, 2024

Method 1 - Use of Fill Handle Icon to Repeat Rows in Excel at Bottom Steps: Select the row up to which cell you want to repeat the values. We ...

How to Repeat Rows in Excel at Bottom: 5 Easy Methods

How to Write 00 in Excel (11 Easy Ways)

Jul 18, 2024

Users can't automatically input numbers with 00 at the front in Excel, but there are ways to go around that restriction. We will consider the ...

How to Sum in Excel If the Cell Color Is Red (4 Easy Methods)

Jul 3, 2024

For the sample data, we have a Sales Report of a certain fruit business. Rows containing undelivered products (marked "Not Delivered") are ...

How to Sum in Excel If the Cell Color Is Red (4 Easy Methods)

How to Fix the ‘Rows to Repeat at Top’ Feature in Excel If Greyed Out (4 Fixes)

Jun 17, 2024

Below is a dataset that represents the sales of various salespersons in different regions. Fix 1: Applying Page Setup from the Page Layout ...

How to Fix the ‘Rows to Repeat at Top’ Feature in Excel If Greyed Out (4 Fixes)

How to Use Comma in Excel Formula (2 Suitable Ways)

Nov 11, 2025

If you're looking for quick and easy ways to use comma in Excel formula, this article will be helpful. While working with Excel, we often need to add ...

How to Use Comma in Excel Formula (2 Suitable Ways)

How to Calculate Budget Variance in Excel – 3 Steps

Aug 10, 2024

The dataset showcases a company’s Actual Revenue, Budget Revenue and the revenue of the previous year. To calculate the Budget Variance for this ...

How to Calculate Budget Variance in Excel – 3 Steps

How to Calculate Letter Grades in Excel (6 Simple Ways)

Jul 5, 2024

Here is an annual grade sheet for 7 students in an institution, with names and marks. We also have grades based on the range of scores. Method 1 ...

How to Calculate Letter Grades in Excel (6 Simple Ways)

How to Make Yes Green and No Red in Excel – 8 Examples

Aug 4, 2024

Example 1 - Highlighting Cells Rules The dataset showcases students' names and math scores. Steps: Enter the following formula in D5 to ...

How to Make Yes Green and No Red in Excel – 8 Examples

If Cell Color Is Green Then Show or Customize Outputs in Excel

May 17, 2024

In the latest version of Excel, it is directly possible to use a specific cell color as the condition when using the IF function. But for previous ...

If Cell Color Is Green Then Show or Customize Outputs in Excel

How to Make a Grade Calculator in Excel (2 Suitable Ways)

Nov 11, 2025

If you are working for a school or any educational institution, then you may need to make a grade sheet calculator describing the grade percentage ...

How to Make a Grade Calculator in Excel (2 Suitable Ways)

How to Use Debt to Equity Ratio Formula in Excel (3 Examples)

Nov 11, 2025

In business, the debt-to-equity ratio is an essential factor to evaluate, because it expresses the condition of a business. We can easily guess the ...

How to Use Debt to Equity Ratio Formula in Excel (3 Examples)

How to Repeat Rows at Top in Excel (3 Suitable Ways)

Jun 20, 2024

How to Repeat Rows at Top in Excel: 3 Suitable Ways The sample dataset contains some items, the quantity of each item, and the total number ...

How to Find Repeated Numbers in Excel (5 Easy Methods)

Jun 18, 2024

To demonstrate our methods, we'll use the following dataset, which contains some Products and their Order no along with the Date. Some numbers are ...

How to Find Repeated Numbers in Excel (5 Easy Methods)

How to Calculate NPS Score in Excel (2 Methods)

Jul 21, 2024

What is NPS? NPS, which stands for Net Promoter Score, provides insights into customer loyalty and satisfaction. It measures the difference between ...