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

[samccune]

still needing a solutio

 

[Patti]

If D3 is the set amount, try:

=$D$3-($D$3*$B6)

in cell D6, and then copy down the D column.