What is 25 out of 25 out of 25

Multiply by a percentage

Note: If you want to find the percentage of a total or the percentage of change between two numbers, see the Calculate percentages article.

Change an amount by a percentage

Say you need to decrease or increase your weekly food expenditure by 25%. To calculate the amount, use a formula to subtract or add a percentage.

In this example, column B is set to contain the amount currently spent and column C is the percentage by which that amount should be reduced. Here is a formula you can type in cell D2 to accomplish this:

= B2 * (1-C2)

In this formula, 1 equals 100%. The values ​​in brackets are calculated first, so the value C2 is subtracted from 1 to get 75%. The result is multiplied by B2 to get a result of 56.25 for week 1.


To copy the formula in cell D2 down the column, double-click the small square green box in the lower right corner of cell D2. You will get the results in all other cells without retyping or copying and pasting the formula.

To increase the amount by 25% increase , just replace that + - Sign in the formula in cell D2 Sign to a minus sign (-):

= B2 * (1 + C2)

Then double-click the handle again.

Multiply an entire column of numbers by a percentage

Imagine an example table like the one in the picture where we need to multiply a couple of numbers by 15 percent. Even if the column contains 100 or 1,000 cells of data, Excel can still process it in just a few steps.

Then proceed as follows:

  1. Put the numbers you want to multiply by 15% in a column.

  2. In a blank cell, type the percentage of 15% (or 0.15), then copy that number by pressing Ctrl + C.

  3. Select the cell range A1: A5 (by dragging the column).

  4. Right-click the cell selector, and then click Paste content (Click Not on the arrow next to it Paste content).

  5. click on values > multiply, and then click OK.

    The result is that all the numbers are multiplied by 15%.


Tip: You can also multiply the column to subtract a percentage. If you want to subtract 15%, add a negative sign before the percentage and subtract the percentage from 1 using the formula = 1-n%, in which n the percentage is. use = 1-15% as a formula to subtract 15%.

Multiply an entire column of numbers by a percentage

In this example we only have a few numbers that can be multiplied by 15 percent. Even if the column has 100 or 1000 cells of data, Excel for the web can process it in just a few steps. To do this, proceed as follows:

  1. Give = a2 * $ C $ 2 in cell B2. (Be sure to include the $ symbol before C and before 2 in the formula.)

The "$" symbol makes the reference to C2 absolute, which means that when the formula is copied to another cell, the reference to cell C2 is always found. If you didn't use $ symbols in the formula and you dragged the formula down into cell B3, Excel for the web would change the formula to = A3 * C3, which won't work because there is no value in C3.

  1. Drag the formula in B2 down to the other cells in column B.

Tip: You can also multiply the column to subtract a percentage. If you want to subtract 15%, add a negative sign before the percentage and subtract the percentage from 1 using the formula = 1-n%, in which n the percentage is. How to subtract 15% use = 1-15% as a formula.