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

[samccune]

=D3-(D3*B#) in which the # is the Row number that the cell is in. So i
this formula were going in cell D20 then it would be =D3-(D3*B20) but
need it to automatically enter that row number after the B, because B i
a constant.



Any help??

 

[Patti]

Not sure I totally understand what you're trying to do,
but if you're trying to make B constant, put a dollar sign
$ in front of B but not in front of the row number:

=D3-(D3*$B20)

 

[Myrna Larson]

Doesn't this formula in D20 work for you? It should

=D3-D3*B20

 

[BenjieLop]

Enter the following formula in cell D3

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

and copy down until you have reached the 150th cell.