Platform
Accounts Payable
Automate your accounts payable workflow - from ERP to your supplier’s bank account.
Global Receivables
Open unique receivable accounts worldwide to collect payments like a local, save on fees, and control currency conversions on your terms.
Currency Conversions
Enjoy consistent rates with 24/7 control.
Treasury Management
Unified financial operations management across borders and entities.
Corporate Cards
Cards tied to your global accounts - spend globally, earn cashback, and eliminate currency conversion fees.
Integrations
Pull and push transaction data with a single click.
Solutions
Tech
See how Finofo solves the pain points of Tech & SaaS companies.
Food & Agriculture
Leverage Finofo’s platform to grow your Agribusiness globally.
E-commerce
Swipe right on better Global Banking
Automobile Industry
Drive growth with smoother, faster international transactions.
Manufacturing
Finofo makes your financial workflows as advanced as your production line.
Retail & Wholesale
Finofo helps you expand beyond borders with ease.
Pricing
Pricing
All the features without any paywalls
Company
About Us
Empowering business finance teams with technology to surpass traditional barriers.
Submit Pitch Deck
Finofo’s “Pay it Forward” program
Resources
Blog
Learn more about Finofo, Technology, Payments, and Banking.
Case Studies
See Finofo in action with our customers’ stories.
Changelog
Product news and updates.
Powerful tools to save you time and money.
Help Center
Product guides, best practices, and FAQs.
Comparison
Using a Bank?
Here’s what your Finance team endures — experience their pain.
Working with an FX Broker?
Are they really looking out for your best interests? Understand the trade-offs.
Using other Fintechs?
Are they truly solving your needs? Compare and see the difference.
Log InBook DemoSign Up
Google Sheets

Calculate Percentage in Google Sheets: A Step-by-Step Guide

Calculating percentages in Google Sheets is a common task for expressing a portion of a whole or comparing values relative to a total. In this step-by-step guide, we'll explore various methods to seamlessly calculate percentages, empowering you to analyze and present your data effectively.

The percentage formula in Google Sheets revolves around the simple concept of dividing one value by another to represent the ratio between them.

Understanding and applying the percentage formula in Google Sheets can significantly enhance one’s productivity and make working with spreadsheets a lot more efficient. This article walks you through various methods to quickly find percentages.

Basic Percentage Formula

The fundamental formula for calculating percentages in Google Sheets is simple: you take the portion, divide it by the total, and then multiply by 100. This formula can be expressed as '(Portion/Total) * 100 = Percentage'. For example, to determine the percentage of $30 out of $200, you would use the formula '($30/$200) * 100', which results in 15%. This calculation shows that $30 is 15% of $200.

To implement this formula in Google Sheets, you can either input the numbers directly or utilize cell references. For instance, if the portion is in cell B1 and the total is in cell B2, your formula would be '= (B1/B2) * 100'. Google Sheets will then automatically compute the percentage based on the values in these cells.

Computing percentages in Google Sheets is versatile and can be adapted to various requirements. Here are some typical approaches-

  • Calculate a Fraction of a Total: Apply the formula '=(portion/total)' or 'C1/D1' if you're using cell references. This approach yields a decimal value that you can format as a percentage.
  • Calculate and Convert to Percentage: Another method is to use the formula '=(portion/total)*100' or '=(C1/D1)*100' when utilizing cell references. This method provides the result directly as a percentage, bypassing the decimal format.
  • Determine Percentage for Specific Conditions: For more intricate calculations, like determining the percentage of cells that satisfy particular conditions, you can employ the 'PERCENTIF' function with the syntax 'PERCENTIF(range, criteria)'. This function formats the outcome as a percentage automatically.

Google Sheets Format Percentage

After calculating percentages, you may want to format the results as percentages to make them easier to read and understand. Google Sheets provides a simple way to do this:

  • Select the cell(s) containing your percentage values.
  • Go to 'Format > Number > Percent' in the Google Sheets menu. This will convert your decimal numbers to percentage format, automatically multiplying them by 100 and adding a percentage sign.

‍

  • You can also use the 'TO_PERCENT' function to format the result as a percentage automatically when calculating it, using the syntax 'TO_PERCENT(value)'.

Incremental Percentage Increase or Decrease

  • Set initial and new values: For example, if an item’s original price (in cell A1) is $100 and the new price (in cell A2) is $120.
  • Calculate the percentage change: In a new cell, type =((New-Original)/Original)*100 (e.g., =((A2-A1)/A1)*100). This will give you the percentage increase.

These straightforward methods help you understand changes in values and assess data trends easily in Google Sheets.