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.
Here are some common types of percentage formulas used in Google Sheets:
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.
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.
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.
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.
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.
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.
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.
