# Percentage Formula in Google Sheets: The Ultimate Guide in 2024

May 8, 2024

## Percentage Formulas in Google Sheets

Percentage formulas in Google Sheets are mathematical expressions used to calculate percentages. These are ratios or fractions expressed as parts of 100 and are essential for tasks ranging from financial analysis and academic grading to data analysis and general arithmetic.

## Examples of Percentage Formulas in Google Sheets

Here are some common types of percentage formulas used in Google Sheets:

### 1. Calculating Percentage of Individual Sales Out of Total Sales

This formula calculates how much a single product's sales contribute to the total sales.

Setup in Google Sheets:

Enter the formula =(Sales of Product/Total Sales)*100 in a cell. Replace 'Sales of Product' and 'Total Sales' with the appropriate cell references.

Press Enter to get the result.

Optionally, format the cell as a percentage. If you prefer to use Google Sheets' percentage formatting (by clicking the '%' icon), you should not multiply by 100 in the formula as Sheets automatically does this when applying the format.

### 2. Percentage Difference Between Two Numbers

This formula calculates the percentage difference between two numbers, which is useful in comparisons like analyzing changes in values over time.

Setup in Google Sheets:

Enter the formula =((Production in Week 2 - Production in Week 1)/Production in Week 1)*100. Insert the weekly production figures in the formula.

Press Enter and format as a percentage if desired.

### 3. Calculating a Number from a Percentage

This formula is used to find out a specific amount from a total given a percentage.

Setup in Google Sheets:

Enter the formula = Original Price * Discount Rate. Replace 'Original Price' and 'Discount Rate' with the relevant cell references.

Press Enter to view the discount amount.

### 4. Adjusting a Number by a Percentage

These formulas are used to increase or decrease a number by a certain percentage.

Setup in Google Sheets:

For an increase, use =Current Charge * (1 + Percentage Increase). For a decrease, use =Current Charge * (1 - Percentage Decrease). Input the current charge and the adjustment rate.

Press Enter to obtain the new charge amount.

### 5. Determining Percentage of a Class's Participation in an Event

This formula is used to find the participation rate of a class in an event.

Setup in Google Sheets:

Use =(Number of Participants/Total Number of Students in the Class)*100. Replace the placeholders with actual data or cell references.

Press Enter and format as a percentage for clarity.

### 6. Analyzing Percentage Distribution of Budget Across Departments

This formula analyzes the distribution of the total budget across various departments.

Setup in Google Sheets:

Enter =(Budget of Department/Total Budget)*100. Substitute the formula parts with the appropriate cell references.

Press Enter to view the percentage distribution.

### 7. Finding the Percentage Score of Students in a Test

This formula calculates students' percentage scores based on their marks in a test.

Setup in Google Sheets:

Enter the formula =(Marks Obtained/Total Marks)*100. Replace 'Marks Obtained' and 'Total Marks' with the corresponding values or cell references.

Press Enter and consider formatting the cell as a percentage for easier interpretation.

We hope that you now have a better understanding of how to use percentage formulas in Google Sheets. If you enjoyed this article, you might also like our article on how to add a multi select dropdown in Google Sheets or our article on how to set up the percentile formula in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
• 27 pages of Google Sheets tips and tricks to save time
• Covers pivot tables and other advanced topics
• 100% free