#1   Report Post  
Daniel - Sydney
 
Posts: n/a
Default Multiplying in a row

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   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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   Report Post  
Daniel - Sydney
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiplying a cell by a set number gunny86 Excel Discussion (Misc queries) 2 September 7th 05 08:52 AM
multiplying an enitre column. Robert Excel Discussion (Misc queries) 2 August 19th 05 04:00 PM
Problem with Excel: Simple multiplying calculations don't work. dforty3 Excel Discussion (Misc queries) 3 July 22nd 05 06:47 PM
Subtracting and multiplying tax numbers witht he IF function Asta Excel Discussion (Misc queries) 2 February 13th 05 06:04 AM
Multiplying in Excel albebach Excel Discussion (Misc queries) 1 February 3rd 05 05:18 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"