multipying percentages

L

Lucky

I need to multiply an entire column by a value i.e 48% to show a discount for all values in the next column. How? thanks.
 
A

Alan

With the data in A1, in B1 =A1*0.48 and copy down
Lucky said:
I need to multiply an entire column by a value i.e 48% to show a discount
Click to expand...
for all values in the next column. How? thanks.
 
G

Gord Dibben

Lucky

Enter .48 in a cell

Copy this cell then select your entire column and Paste
Special>Multiply>OK>Esc.

Clear Contents on the cell with .48

Gord Dibben Excel MVP
 
Top