< Go Back

Get amount with percentage

If you have totals and percentages show a portion of the total in Excel, you can use the multiplication symbol (*) to quickly find an amount that represents a certain percentage of the original value. This method is very easy to use in excel.

To get amount with the percentage of the total, use a multiplication formula, using cell references instead of numbers.

=B2*C2

Formula

=total*percent

Explanation

Get amount with percentage uses the following arguments:

  • Total: It is the total amount of some calculation.
  • Percent: It is a percentage whom you wish to calculate the amount from the total value.

Example 1

As shown in the figure the total cost of day 1 is 600 and we want to find 20% of the total cost. To get a mount with a percentage, we will use a simple excel formula, B2*C2. This formula will multiply the value place in B2(600) and percentage placed in C2(20% or 0.20).

We will use this formula in D2 cell and will drag it down for all values, It will simply calculate results. Figure 1. Example of geting amount with the percentage

Example 2

Suppose we have a bookstore, we wish to give our customers an of 20% off on all products. By using formula “ =B2*C2 ” we will get the amount of percentage that is off on each product.

 

Figure 2. Example of getting amount with the percentage

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar