Mixed reference copying 1
You enter the formula =B2*$C$1 in cell D2 and drag it down using the fill handle ✚. The multiplier $C$1 must stay fixed, while B2 must update. What will the formula in cell D3 be?
=B3*C1=B2*$C$1=B3*$C$1=B3*$C1
You enter the formula =B2*$C$1 in cell D2 and drag it down using the fill handle ✚. The multiplier $C$1 must stay fixed, while B2 must update. What will the formula in cell D3 be?
=B3*C1=B2*$C$1=B3*$C$1=B3*$C1