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

S

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.

:confused:

Any help??
 
P

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)
 
B

BenjieLop

Enter the following formula in cell D3

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

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