| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I multiply columns?
I want to multiply a column by $2.5. I want to enter one formula so that
whatever numbers in column c is multiplied by $2.5. Numbers in column c vary, but I want them all multiplied by the same number |
|
#2
|
|||
|
|||
|
simplest way is to enter 2.5 into an empty cell select that cell and copy it
select the column you want to change and paste special multiply "Horizon Dude" wrote: I want to multiply a column by $2.5. I want to enter one formula so that whatever numbers in column c is multiplied by $2.5. Numbers in column c vary, but I want them all multiplied by the same number |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
| can't insert columns between columns | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Linear Mode
