G Guest Apr 22, 2004 #1 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.
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 Apr 22, 2004 #2 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.
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 Apr 22, 2004 #3 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
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
