From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

Free Percentage Calculator Online: Calculate Percent

Free percentage calculator online, calculate percent banner

A percentage calculator is a tool that helps you with math involving percentages. It can find a percentage of a number, increase/decrease a number by a percentage, and more. It helps you with any calculation that involves %.

Percentage Calculator

How much is X percent of?
% of =
X is what percent of value?
is % of
X percent of value is what?
is % of
What is the difference between value 1 and value 2 in percentage?
Difference between and =

What is a percentage?

A percentage is a way of expressing a part of something out of a whole, but that whole is always considered to be divided into 100 parts. So, 50% means 50 out of 100, or half. We use the % symbol to represent the percentage.

Percentage visualization example, screenshot with 0%
Screenshot with percentage visualization

Looking to create reporting system fast & painlessly?
Build dashboards and track KPIs in one place with Ajelix BI

Dashboard example from Ajelix BI

Start free

Percentage Formula

There are two main formulas for percentages:

  1. Finding a percentage of a number:
    • Percent (%) / 100 × Number (what you want to find the percentage of) = Your answer (%)
  2. Converting a part of something to a percentage of the whole:
    • (Part / Whole) × 100 = Your answer (%)
FormulaDescription
(%) / 100 × NumberFind a percentage of a number
(Part / Whole) × 100Convert a part to a percentage of the whole
Two percentage formulas

What is percentage change?

Percentage change refers to the relative difference between two values, expressed as a percentage. It tells you how much a value has increased or decreased compared to its original value.

Percentage Change Formula

[(New Value – Old Value) / |Old Value|] × 100

Percentage change calculation chart from ajelix bi example
Example chart showcasing percentage change between 2 months, image by author created on Ajelix BI

Where,

  • New Value: This is the final value you’re comparing to the original value. For example, “Sold items in April”
  • Old Value: This is the initial value you’re using as the baseline for comparison. For example, “Sold items in March”
  • |Old Value|: This represents the absolute value of the original value. The absolute value ensures the result is a positive percentage regardless of whether the change is an increase or decrease.
  • × 100: This part converts the decimal result into a percentage by multiplying by 100. If you calculate in Excel, then you can skip this step and choose “%” formatting.

Key points:

  • If the result is positive, it indicates a percentage increase.
  • If the result is negative, it indicates a percentage decrease.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

Related Article:How To Calculate Revenue Growth Rate: Formula & Examples

How to calculate percentage change?

Let’s say you want to calculate the percentage change between sold item value in March and April. Sold table value in March is 400$ and 350$ in April. Let’s calculate the percentage change:

  • New Value (April) = $400
  • Old Value (March) = $350
Calculate percentage change in excel with formula screenshot
Screenshot from Excel with example data on how to calculate percentage change, image by author

Percentage Change = [($350 – $400) / |$400|] × 100 = ($50 / $350) × 100 = 0.125 × 100 = -12.5%

Therefore, the sold amount value decreased by 12.5%.

What is the Percentage Difference?

The percentage difference tells you the relative magnitude of the difference between two quantities, expressed as a percentage. It considers the average of the two values, unlike percentage change which focuses on the original value.

In simpler terms, it shows how big the difference is compared to the average size of the two numbers you’re comparing, all expressed as a percentage.

Percentage Difference Formula

ExpressionDescription
Formula(a – b) / [(a + b) / 2]
aFirst number
bSecond number
Percentage difference formula

How to calculate the percentage difference?

Imagine you have two test scores: 70 and 90. What’s the percentage difference between them?

  1. Calculate the difference: 90 – 70 = 20.
  2. Find the average: (70 + 90) / 2 = 80.
  3. Apply the formula: |(90 – 70)| / [(90 + 70) / 2] × 100 = 20 / 80 × 100 = 0.25 × 100 = 25%

Therefore, the percentage difference between the scores is 25%. This means the difference (20 points) is 25% of the average score (80 points).

Related Article:7 Best AI For Data Analysis: Tools You Can’t Miss

how to get a percentage of a number?

Finding what percent a number is of another number (a part out of a whole):

Finding a percentage of the number screenshot from Excel with formula
Screenshot from Excel with formula on how to get a percentage of a number, image by author
  • Formula: (Part / Whole) × 100 = Your answer (%)
    • Part: This is the number you want to express as a percentage of the whole.
    • Whole: This is the total amount or reference value.
  • Example: Let’s say you scored 80 points on a test out of 100 possible points. What percentage is your score (80) of the total (100)?
    • Part = 80 points
    • Whole = 100 points
    • (80 points / 100 points) × 100 = 80%

Related Article:Generative AI For Data Analytics: What You’re Missing Out

how to calculate percentages in Excel

Here’s a step-by-step guide to help you calculate percentages in an Excel spreadsheet:

  1. Enter your data:

    Start by entering your data into the spreadsheet. For example, if you’re calculating the percentage of items sold out of total stock, you’d have a column for “Items Sold” and another for “Total Stock”.
    Example stock data in Excel spreadsheet for percentage calculation screenshot from spreadsheet

  2. Choose a cell for the percentage

    Select a blank cell where you want the percentage value to be displayed.
    Excel example data formatting for percentage calculation screenshot

  3. Apply the formula

    In the chosen cell, type the following formula: =part/total*100
    – Replace “part” with the cell reference containing the value you want a percentage of (e.g., cell B2 for “Items Sold”).
    – Replace “total” with the cell reference containing the total value (e.g., cell C2 for “Total Stock”).
    Percentage formula calculation in Excel screenshot with formula

  4. Format cell as a percentage

    By default, Excel displays the result as a decimal. To format it as a percentage, select the cell and click on the “Percent Style” button (%) in the Home tab. This will convert the decimal to a percentage with two decimal places (e.g., 20.00%).
    Cell formatting using Excel percentage settings screenshot

  5. Autofill (optional)

    If you need to calculate percentages for multiple rows with the same formula, you can simply copy the formula down to the other cells. Drag the corner of the cell containing the formula downwards to fill the formula in the following cells. Excel will automatically adjust the cell references within the formula for each row.
    How to autofill percentage formula in Excel, screenshot with steps

Related Article:Data Analytics For Small Business Best Practices With Examples

How To Calculate Percentages With AI?

Even spreadsheets are getting smarter! AI can now help with percentage calculations by automatically generating formulas based on your descriptions.

1. Create a free Ajelix account

Ajelix offers over 15 AI-powered tools, including an Excel formula generator. Sign up easily with your Gmail or any email address.

Register on ajelix.com and create a free account to generate formulas screenshot from platform

Screenshot from Ajelix registration page, image by author

2. Locate the Formula generator tool

Once you have logged in to the portal you can find the Excel formula generator under the AI tools section.

Find the ai tool for formula creation screenshot from ajelix portal with steps

Screenshot from Ajelix portal on how to find formula generator, image by author

3. Write a clear and concise prompt

Forget the times you needed to memorize formulas! Ajelix AI understands your goals in plain English. Simply describe what you want to calculate, for example, if you want a percentage formula, write “I have March sales in cell B2 and April sales in C2 and I want to understand the change in sales between these months”. AI then takes care of the complex formula for you, ensuring accuracy and saving you time.

Prompt for AI for percentages calculation in excel formula screenshot

Screenshot from Ajelix formula generator with Percentage prompt, image by author

4. Get your formula

Once you have the prompt AI will give you a ready-to-use formula to insert in your spreadsheet. You can also use Excel or Google Sheets add-on for easier formula writing. In the answer below you can see that AI gave the correct formula to calculate the percentage change between two months.

Answer from AI with excel percentage formula screenshot

Screenshot from Ajelix with percentage formula result, image by author

Ready to give it a go?
Test AI tools with freemium plan and only upgrade if formula generator can help you!

Give it a go

Related Article:Free NPV Calculator Online: Calculate Net Present Value

Download Percentage Calculator In Excel Template

Percentage calculator in Excel template screenshot
Screenshot from Excel with Percentage calculator, image by author

Download your free percentage calculator below 👇

How To Convert Percentage to Decimal?

Divide the percentage by 100 (or move the decimal two places to the left) and remove the percent sign (%):

Example: Convert 25% to a decimal.

25% / 100 = 0.25

Screenshot from excel on how to convert percentage to decimal number
Screenshot from Excel with formula on how to convert percentage to decimal, image by author

Related Article:Top 10 Best Business Intelligence Tools Comparison

How To Convert Decimal to Percentage?

Multiply the decimal by 100 (or move the decimal two places to the right) and add a percent sign (%):

Example: Convert 0.75 to a percentage.

0.75 x 100 = 75%

Screenshot on how to convert decimal to percentage in Excel
Screenshot on how to convert decimal numbers to percentages in Excel, image by author

Remember:

  • Dividing by 100 essentially reduces the number by a factor of 100 (like moving the decimal left) because a percentage represents a part out of 100 parts.
  • Multiplying by 100 increases the number by a factor of 100 (like moving the decimal right) to express it as a part out of 100 (percentage).

Related Article:How To Add Checkboxes In Excel

Most Common Mistakes Calculating Percentages

  • Misunderstanding percentages: People might forget that a percentage represents a part of a whole divided by 100. This can lead to confusion about what numbers to use in the calculation.
  • Adding or subtracting percentages directly: When dealing with consecutive percentage changes (discounts, markups), it’s tempting to simply add or subtract the percentages. This is incorrect because each percentage is based on a different starting value. You need to calculate them sequentially.
  • Converting between percentages and decimals: Not converting percentages to decimals (dividing by 100) before using them in calculator functions can lead to wrong answers.
  • Confusing part and whole: Especially in word problems, it can be tricky to identify which number is the part (represents the percentage) and which is the whole.
  • Misplacing the decimal point: Percentages are often expressed as decimals, and even a slight mistake in decimal placement can significantly alter the outcome.

Tips to avoid these problems

  • Identify the whole and the part: Clearly define which number represents the whole quantity and which represents the percentage of that whole.
  • Write down the formula: Depending on the problem, there might be a specific formula to follow. Writing it down can help structure your approach.
  • Use a pen and paper for complex problems: If the problem has multiple steps or involves several percentages, working it out on paper can help avoid confusion.
  • Check your work: After calculating the answer, take a moment to review your steps and see if it makes sense in the context of the problem.

FAQ

What is a percentage calculator and what can it do?

A percentage calculator is a tool that simplifies finding percentages. It can help you: Find a part of a whole (e.g., what’s 20% of 100?). Express a part as a percentage of a whole (e.g., what percentage of 20 is 4?).

How do I avoid mistakes with decimals when calculating percentages?

Convert percentages to decimals first: Before using a percentage in a calculation, divide it by 100.
Double-check decimal placement: Pay close attention to where the decimal point falls in your answer. A small mistake in placement can significantly change the result.

How do I handle consecutive percentage changes (discounts, markups)?

Don’t directly add or subtract consecutive percentages. Calculate them one at a time:
Start with the original price (100%). Apply the first percentage change (discount or markup) as a multiplication or division (depending on increase or decrease).

How can I estimate percentages without a calculator?

Round the whole number or percentage to a nearby multiple of 10 or 25 for easier calculations. Benchmarks: 10% is roughly equal to 1 item out of 10. 25% is like 1 out of 4. 50% is simply half. 75% is around 3 out of 4. Adjust your answer based on how much you rounded the initial numbers.

Setup and monitor your KPIs regularly using Ajelix BI

Ad hoc financial analysis report example from ajelix bi portal