Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I need to multiply a row of numbers by 30%, the row extends from A4 to W4. How do I do it. thanks Daniel |
#2
![]() |
|||
|
|||
![]()
You want A4:W4 to be 130% of their curretn values?
Type 1.3 in a cell. Then, copy that cell. Select A4:W4. Go to Edit | Paste Special. Choose Multiply and click Okay. -- tj "Daniel - Sydney" wrote: Hi I need to multiply a row of numbers by 30%, the row extends from A4 to W4. How do I do it. thanks Daniel |
#3
![]() |
|||
|
|||
![]()
Thanks for your help
Daniel "tjtjjtjt" wrote: You want A4:W4 to be 130% of their curretn values? Type 1.3 in a cell. Then, copy that cell. Select A4:W4. Go to Edit | Paste Special. Choose Multiply and click Okay. -- tj "Daniel - Sydney" wrote: Hi I need to multiply a row of numbers by 30%, the row extends from A4 to W4. How do I do it. thanks Daniel |
#4
![]() |
|||
|
|||
![]()
Enter .3 in an unused cell.
Select and copy. Select A4:W4 and Paste SpecialMultiplyOkEsc. Gord Dibben Excel MVP On Mon, 26 Sep 2005 16:05:02 -0700, Daniel - Sydney <Daniel - wrote: Hi I need to multiply a row of numbers by 30%, the row extends from A4 to W4. How do I do it. thanks Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiplying a cell by a set number | Excel Discussion (Misc queries) | |||
multiplying an enitre column. | Excel Discussion (Misc queries) | |||
Problem with Excel: Simple multiplying calculations don't work. | Excel Discussion (Misc queries) | |||
Subtracting and multiplying tax numbers witht he IF function | Excel Discussion (Misc queries) | |||
Multiplying in Excel | Excel Discussion (Misc queries) |