Need help applying a formula to a certain area of the worksheet
 

I am trying to multiply a value to a set of current data on a work
sheet. The value is 0.7 and the range of cells is B4:N33 for example.
Can anyone help me with this??

Thanks-
Pirouz


--
pirouz
------------------------------------------------------------------------
pirouz's Profile: http://www.excelforum.com/member.php...o&userid=34868
View this thread: http://www.excelforum.com/showthread...hreadid=546191

Need help applying a formula to a certain area of the worksheet
 

Enter 1.07 in an unused cell. Copy that cell

Select B4:N33
Goto EditPasteSpecial
Click Multiply
OK

Clear the 1.07 from the cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"pirouz" wrote in
message ...

I am trying to multiply a value to a set of current data on a work
sheet. The value is 0.7 and the range of cells is B4:N33 for example.
Can anyone help me with this??

Thanks-
Pirouz


--
pirouz
------------------------------------------------------------------------
pirouz's Profile:
http://www.excelforum.com/member.php...o&userid=34868
View this thread: http://www.excelforum.com/showthread...hreadid=546191

Need help applying a formula to a certain area of the worksheet
 

Thank you very much!


--
pirouz
------------------------------------------------------------------------
pirouz's Profile: http://www.excelforum.com/member.php...o&userid=34868
View this thread: http://www.excelforum.com/showthread...hreadid=546191