Excel Formulas to Calculate the Amount based on Percentage!!
Tags: excelformula, excelformulas
Published: 2021-07-06 09:33:11

---
title: Excel Formulas to Calculate the Amount based on Percentage!!
published: true
date: 2021-07-02 06:02:22 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-amount-based-on-percentage/
---

We often have to work with percentages in our day-to-day work and our everyday life. Excel makes this task easier by automatically applying basic or advanced formulas that allow you to calculate percentages directly in your spreadsheets. Here we will show the formulas **to calculate the amount based on the given percentage in Excel**. Let’s jump into this article! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get the amount by percentage](https://geekexcel.com/wp-content/uploads/2021/07/Get-the-amount-by-percentage.png)](https://geekexcel.com/excel-formulas-to-calculate-the-amount-based-on-percentage/get-the-amount-by-percentage/#main)<figcaption id="caption-attachment-48342">Get the amount by a percentage</figcaption>

## Generic Formula:

- You can use the below formula to calculate the amount represented by a percentage when the total is known in Excel.

**=percentage\*total**

## Syntax Explanations:

- **Percentage** – It specifies the percentage value.
- **Total** – This term represents the total amount.
- **Multiplication (\*)** – In this symbol will multiply any two values or numbers.

## Practical Example:

Let’s consider the below example image.

- Here we will enter the input values in **Column B** and **Column C**.
- Now we need to get the amount of the given percentage value based on the total amount which is given in **Cell D2**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-6.png)<figcaption id="caption-attachment-48343">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula-4.png)<figcaption id="caption-attachment-48341">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result-5.png)<figcaption id="caption-attachment-48344">Result</figcaption>

## Conclusion:

From this tutorial, you can get to know the **formulas to calculate the amount based on the percentage value in Excel**. Please write us below if something is unclear or if you need further assistance on this subject.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Get the Last Name from Full Name ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-last-name-from-name/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Surface Area of a Cone ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-surface-area-of-a-cone/)**
- **[Excel Formulas to Get Domain from Email Address ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-domain-from-email-address/)**