| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to multiply whole of excel table by some constant
hellow
can it be possbile to multiply whole of an excel table by some constants. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to multiply whole of excel table by some constant
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is it possible to multiply whole of excel table by some constant
yes
A B C D E F 1 3 9 7 2 6 2 1 3 4 8 3 4 5 7 In cell D1 you can do =A1*$A$5 and then autofill across and down this multiplies everything in table A1:C3 by 7 -- Allllen "vijaya reddy" wrote: hellow can it be possbile to multiply whole of an excel table by some constants. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help Creating a Macro to Multiply Cells by a Constant Number | Excel Discussion (Misc queries) | |||
| can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| Find data in table with to set of constant values | Excel Worksheet Functions | |||
| Multiply by a constant | Excel Discussion (Misc queries) | |||
Hybrid Mode
