# 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:

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

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

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

Right-click the cell selector, and then click

**Paste content**(Click**Not**on the arrow next to it**Paste content**).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

**the percentage is. use**

*n***as a formula to subtract 15%.**

**= 1-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:

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.

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.

- How is OTP safe?
- What are the largest edible marine animals
- Can people treat you badly
- Fruity loops or pro tools
- How did Britain manage to conquer Burma?
- How do interns learn experiences
- Why is pedophilia so common
- Why does zinc nitrate decrease when heated
- Where can we watch IPL games live
- The farmers earn more money

- Who started the night club table service
- What channels do I get with Disney
- Psychopaths admire people
- How do I make a VR game
- How can I send free products
- Is mineral water actually healthier?
- What will the future of Viddy be
- How do I comfort a bereaved
- What is the maximum covalency of oxygen
- Are old Britannica encyclopedias worth anything?
- What is a substitute for watercress
- Boiling hot peppers reduce their heat
- How can I prevent myself from distancing myself while meditating?
- Why are Linux software names weird
- What is the subject of Deuteronomy
- Is the Safari browser for Windows
- Which countries already have refugees from climate change?
- How is the pitch directly proportional to the frequency
- How can I forward emails to Outlook
- Boris Johnson makes you nervous
- Cuddling a dog causes behavior problems
- Can we eat broccoli flowers
- Bipolar disorder may cause irritability
- What are home decor mistakes to avoid