Entire row * 3%

anakaine

New Member
Joined
Nov 7, 2005
Messages
6
This is probably an easy question, I'm just struggling with...

I have a column of values beginning at column I row 2 that will periodically need to be multiplied by 3% (ie 1.03).

From row two, until the bottom of the column, where there is no more data.

How would I go about this?

The worksheet name is "myprodlist"
I am using Excel 2003 on Win XP SP2



Any help is greatly appreciated
Thankyou
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Put 1.03 in an empty cell.
Copy this cell.
Select your range to multiply.
Click on Edit, then Paste Special
Select Multiply
Click OK.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,499
Members
412,670
Latest member
Khin Zaw Htwe
Top