=D3-(D3*B#) in which the # is the Row number that the cell is in

samccune · Sep 22, 2004

Cell D3 is a set ammount. 55 [dollars]

the formula that needs to be repeated starts in D6 and would loo
like:

=D3-(D3*B6

Biff · Sep 22, 2004

Hi!

Try this:

=D3-(D3*INDIRECT("B"&ROW()))

Biff