# Multiplying

#### Burdette

##### Board Regular
Getting Old and forgot how to multiply a set of numbers in a column by a fixed number and have the results appear in the same column? Also round the results to two decimal places.

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### PA HS Teacher

##### Well-known Member
Enter the desired multiplier in a blank cell.

Copy that Cell.

Highlight the Column in question.

Edit, Paste Special, Values, Check Multiply.

As far as rounding, if you just want to display the numbers to N decimal places, format, cells, number.

#### gardnertoo

##### Well-known Member
Type the number by which you want the column multiplied in some spare cell.
Select that cell and copy it (Ctrl+C).
Select the cells you want multiplied.
Right-click, Paste Special
One of the choices is "Multiply". Do that. This replaces each value with value x N

To DISPLAY fewer digits (while leaving the underlying number unedited) you can click the "Decrease Decimal" button (looks like this:

.00
->.0

To actually round the number in A1 to a certain number of digits (two digits in this example), use this formula in another cell: =ROUND(A1,2)

#### Burdette

##### Board Regular
Thanks...

It would help me if I just thought rather than panic.

I like to show students the effect of rounding as that can be very worthwhile in business

#### gardnertoo

##### Well-known Member
And here's an example of the difference between rounding to 2 decimal places and merely showing 2 decimal places. The sum in the "Show 2" column appears to be wrong. It's not, it's correctly summing the numbers including the non-displayed digits:
outlawspeeder.xls
KLMN
14RawShow 2Round 2
1522.14422.1422.14
163.2343.233.23
175.3245.325.32
1830.70230.7030.69
Sheet1

#### Burdette

##### Board Regular
Understand...I usually use an example of 2 places and Round when I show an example of changing the price a certain %...interestingly over time there is little difference in the total but there can be real differences in individual items

Replies
0
Views
275
Replies
3
Views
374
Replies
2
Views
304
Replies
4
Views
314
Replies
0
Views
186

1,191,170
Messages
5,985,061
Members
439,937
Latest member
MAlhash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back