Hi,
Since I don't know if you have hundreds of items, a huge number of different offers etc, I base my solution on what you have sent.

The quick and easy solution is to change cell C2 from "=H8-B2" into "=H8-B2-$B$5". Copy this formula down to C3 and C4.

Kind regards
Bjorn