Free Percentage Calculator Online: Calculate Percent

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*

Before you jump in...
Looking to create reporting system fast & painlessly? Check our latest Ajelix BI platform for easy data analytics to help you make data driven decisions.

Give it a go

Percentage Formula

There are two main formulas for percentages:

Finding a percentage of a number:
- Percent (%) / 100 × Number (what you want to find the percentage of) = Your answer (%)
Converting a part of something to a percentage of the whole:
- (Part / Whole) × 100 = Your answer (%)

Formula	Description
(%) / 100 × Number	Find a percentage of a number
(Part / Whole) × 100	Convert 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

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

Expression	Description
Formula	(a – b) / [(a + b) / 2]
a	First number
b	Second 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?

Calculate the difference: 90 – 70 = 20.
Find the average: (70 + 90) / 2 = 80.
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).

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%

how to calculate percentages in Excel

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

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”.
Choose a cell for the percentage
Select a blank cell where you want the percentage value to be displayed.
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”).
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%).
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 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

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 👇

Calculate-Percentage-Template Download

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*

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.