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

P

pirouz

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

Thanks-
Pirou
 
B

Bob Phillips

Enter 1.07 in an unused cell. Copy that cell

Select B4:N33
Goto Edit>PasteSpecial
Click Multiply
OK

Clear the 1.07 from the cell.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top