finding the value I need to reach a set point

in the attached document I have 3 cells B7 C7 D7 i need a formula in C7 that will tell me how much I need to add or subtract to B7 to make it eqaul D7. I tried simple D7-B7 and visa versa but I keep getting negative that should really be pluses.


BARREL WEIGHTS Test.xlsm

The formula is:-

=D7-B7

you have =sum(=D7-B7) in your spreadsheet.

That didn't work it still gave me -19 in the first 1 and I need it to give me 19 since that how many pounds it would take to get to D7. My issue I believe is that B seven is not always smaller than D7 and visa versa

Are you saying that you always want the result to be positive? is so try

=abs(d7-b7)