- Home
- Data Visualization
- Tools
- Excel Formula Generator
- Excel Formula Explainer
- Google Apps Script Generator
- Excel VBA Script Explainer
- Excel VBA Script Generator
- Excel VBA Code Optimizer
- Excel VBA Code Debugger
- Google Sheets Formula Generator
- Google Apps Script Explainer
- Google Sheets Formula Explainer
- Google Apps Script Optimizer
- Google Apps Script Debugger
- Excel File Translator
- Excel Template Generator
- Excel Add-in
- Your Virtual AI Assistant For Excel Spreadsheets
- AI Answer Generator
- AI Math Solver
- AI Graph Generator

- Pricing
- Resources

From data to report in one minute or less. Ajelix BI is launched! ðŸš€ Get started for free.

- Home
- Blog
- Calculators
- 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 %.

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
=
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.

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

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 |

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.

**[(New Value – Old Value) / |Old Value|] Ã— 100**

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**.

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.

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

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

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

Therefore, the sold amount value decreased by 12.5%.

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.

Expression | Description |
---|---|

Formula | (a – b) / [(a + b) / 2] |

a | First number |

b | Second number |

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).

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

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

**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

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.

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

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

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

*Screenshot from Ajelix registration page, image by author*

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

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

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.

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

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.

*Screenshot from Ajelix with percentage formula result, image by author*

Test AI tools with freemium plan and only upgrade if formula generator can help you!

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

Download your free percentage calculator below ðŸ‘‡

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

**Related Article:** Top 10 Best Business Intelligence Tools Comparison

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%

**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

**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.

**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.

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?).

**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.

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).

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.

July 9, 2024

An EBITDA calculator is a tool that helps you calculate a company’s Earnings Before Interes…

July 4, 2024

An EBIT calculator is a tool that helps you calculate a company’s earnings before interest …

July 2, 2024

A business loan calculator is a tool that helps you estimate the monthly payments, total interest…

June 27, 2024

A dividend calculator is a financial tool that helps investors figure out how much money theyR…

June 25, 2024

An ROI calculator is a tool that helps you figure out the return on investment for something. ROI…

June 18, 2024

A present value calculator is a tool that helps you figure out how much money you’d need to…

July 23, 2024

Financial KPIs are quantifiable metrics that businesses use to track their financial health and p…

July 18, 2024

Ecommerce KPIs track how well your online store is performing. These metrics provide insights int…

July 16, 2024

Accounting KPIs are measurable metrics that track how well an accounting department is performing…

July 11, 2024

Quality KPIs are key performance indicators for quality management used to assess a company’…

May 10, 2024

Unleash the true power of your data! ðŸ’¥ Ajelix, the dynamic AI-powered BI platform built for SMBs,…

April 18, 2024

Organizations across all industries are turning to data analytics to inform strategic decisions, …