Put your dollar figure in B1 and in A1 put:

=$B$1*0.1*ROW() and copy down
--
Gary''s Student - gsnu200782


"amatur wkr" wrote:

I would like to generate a list 0.1 to 30.0 (in 1/10th increments) but each
to be multiplied by a specific dollar figure. How do I multiply each cell by
the same number but don't have to enter the formula on each line?