Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
constant multiplier
-- halegria I have a spread sheet with multiple columns that need to be multiplied by a constant number, is there a format or a formula that will allow me to drag or do it all in one fell swoop as opposed to multiplying each cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
constant multiplier
Try this...
Enter your multiplier in a cell Copy that cell: EditCopy Select the range of cells you want multiplied Then: EditPaste SpecialMultiplyOK Delete the multiplier -- Biff Microsoft Excel MVP "hugoalegria" wrote in message ... -- halegria I have a spread sheet with multiple columns that need to be multiplied by a constant number, is there a format or a formula that will allow me to drag or do it all in one fell swoop as opposed to multiplying each cell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
constant multiplier
I am trying to do this same thing, but what I get is the actual dollar figure
of the percentage itself, it's not ADDING to each individual cell where my totals are located (in dollar amounts). I don't need them added by column or row, simply that each dollar amount within the cells is multiplied by 2% and a formula that will continue that as new amounts are entered. -- Lin242 "T. Valko" wrote: Try this... Enter your multiplier in a cell Copy that cell: EditCopy Select the range of cells you want multiplied Then: EditPaste SpecialMultiplyOK Delete the multiplier -- Biff Microsoft Excel MVP "hugoalegria" wrote in message ... -- halegria I have a spread sheet with multiple columns that need to be multiplied by a constant number, is there a format or a formula that will allow me to drag or do it all in one fell swoop as opposed to multiplying each cell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
constant multiplier
If you want to increase by 2% then enter 1.02 as the multiplier.
-- Biff Microsoft Excel MVP "Lin242" wrote in message ... I am trying to do this same thing, but what I get is the actual dollar figure of the percentage itself, it's not ADDING to each individual cell where my totals are located (in dollar amounts). I don't need them added by column or row, simply that each dollar amount within the cells is multiplied by 2% and a formula that will continue that as new amounts are entered. -- Lin242 "T. Valko" wrote: Try this... Enter your multiplier in a cell Copy that cell: EditCopy Select the range of cells you want multiplied Then: EditPaste SpecialMultiplyOK Delete the multiplier -- Biff Microsoft Excel MVP "hugoalegria" wrote in message ... -- halegria I have a spread sheet with multiple columns that need to be multiplied by a constant number, is there a format or a formula that will allow me to drag or do it all in one fell swoop as opposed to multiplying each cell? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
constant multiplier
Hi,
When you say multiply by 2% do you literally mean that. For example 100 * 2% =2. for this your multiplier is 0.02 or do you mean Add 2% i.e. 100 + 2% = 102. If it's the latter then you put 1.02 in a cell and copy it. Mike "Lin242" wrote: I am trying to do this same thing, but what I get is the actual dollar figure of the percentage itself, it's not ADDING to each individual cell where my totals are located (in dollar amounts). I don't need them added by column or row, simply that each dollar amount within the cells is multiplied by 2% and a formula that will continue that as new amounts are entered. -- Lin242 "T. Valko" wrote: Try this... Enter your multiplier in a cell Copy that cell: EditCopy Select the range of cells you want multiplied Then: EditPaste SpecialMultiplyOK Delete the multiplier -- Biff Microsoft Excel MVP "hugoalegria" wrote in message ... -- halegria I have a spread sheet with multiple columns that need to be multiplied by a constant number, is there a format or a formula that will allow me to drag or do it all in one fell swoop as opposed to multiplying each cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i use =product(cell,multiplier), the box ... only shows ### | Excel Discussion (Misc queries) | |||
Multiplier | New Users to Excel | |||
how can prices be changed by one multiplier? | Excel Discussion (Misc queries) | |||
Counter variable and a multiplier | Excel Discussion (Misc queries) | |||
how to create a repeat formula using the same multiplier? | Excel Worksheet Functions |