Excel: Subtracting a number to always match the total

Question

I want a function that automatically subtracts the current number to match the total.

For example:

I have $54,721.96 total and need my result to be $10,000. I need the formula to find the number that will equal $10,000 (so for this instant "$44,721")

visual example:https://i.sstatic.net/2NExT.png

result example:https://i.sstatic.net/gazsK.png

Answer 1

For this problem, you just have to insert a function in another cell that subtracts the result from the total.

function used in the cell B2 is =A2-C2
Hope this helps you :o