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

P

Patti

If D3 is the set amount, try:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill cells based on the other 3 cells unique combination the value on the target cell 0
My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! 2
=D3-(D3*B#) in which the # is the Row number that the cell is in 3
Sums - D4 MINUS D3 EQUALS D5 2
=D3-(D3*B#) in which the # is the Row number that the cell is in 1
Row references 1
Referring to a cell by using another cell for the row number 6
what does IF(D3="," mean please 1

Top