In B1 enter:

=A1*$C$1

and copy down

In C1, put your multipler. When you change C1, all the products will change.
--
Gary''s Student - gsnu200908


"wineforyou" wrote:

if I have two columns A and B. A is filled with numbers that I want to
multiply by the same number and have that total fill B. But I want also to be
able to change the number and have all the totals update....how?