The print job has 80 copies in B2 and 120 in B3. Put the rate 0.15 in F1. In C2 enter =B2*$F$1 and fill down.

Read the copied formula as two addresses

C3 should say =B3*$F$1 and show 18, while C2 shows 12. Both dollar signs keep the rate on F1. A single dollar sign keeps either the column or the row fixed.

The copied formulas use different quantity cells and the same $F$1 rate.

Illustrated relative and absolute references.

Move one source at a time

In a copy set F1 to 0.20. Expect 16 and 24. Then set B3 to 100 and expect 16 and 20. Check the final copied row too, since it is easy for a rate cell to shift outside the visible area.

Changing F1 from 0.15 to 0.20 changes both costs from 12 and 18 to 16 and 24.

Illustrated rate-change check.

Related Microsoft Excel reference