How to Multiply Column by a Percentage in Google Sheets

To multiply a column by a percentage in Google Sheets, you can use a simple formula. Here's how you do it:

1. Open your Google Sheets document or create a new one.
2. Identify the column you want to multiply by a percentage. For example, let's say you have a list of values in column A and you want to multiply them by 20%.
3. Click on an empty cell where you want to display the result of the multiplication. In this example, let's use cell B1.
4. Type the following formula in cell B1: =A1*20% and press Enter. This will multiply the value in cell A1 by 20% and display the result in cell B1.
5. Now, to apply this formula to the entire column, click on cell B1 to select it, and move your cursor to the bottom right corner of the cell until it turns into a blue crosshair.
6. Click and drag the corner down to fill the desired number of cells in the column with the formula. As you drag, the formula will automatically adjust to reference the corresponding cell in column A.

That's it! You've successfully multiplied a column by a percentage in Google Sheets.

Example

Let's say you have the following data in your Google Sheet:

A       B
--------------
1    100
2    200
3    300
4    400
5    500

You want to multiply the values in column A by 10%. Follow these steps:

1. In cell B1, enter the formula =A1*10%.
2. Press Enter. The result in cell B1 should now be 10, which is 10% of 100.
3. Click on cell B1 and move your cursor to the bottom right corner until it turns into a blue crosshair.
4. Click and drag the corner down to fill cells B2 to B5 with the formula.
5. The formula will automatically adjust as you drag, and the results will be displayed in column B as follows:

A       B
--------------
1    100    10
2    200    20
3    300    30
4    400    40
5    500    50

Column B now contains the values of column A multiplied by 10%.