Excel - Cell always to be a certain value but use another cell's value in the formula

[scubafrog79]

How can I make the value of a cell be a certain amount but use the amount of another cell and then add the difference to the value I want. To make things simple. Let's say that I want the "target" cell to always equal 1 million but the other cell is 250K. How can I create a formula to grab the 250K and know to add 750K to make the "target" cell 1 million.

 

[SkipVought]

What's the business case?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[scubafrog79]

Never mind I figured it out.

=cell with value + SUM(1000000-cell with value)

 

[SkipVought]

Do you realize how trivial?

1000000-cell+cell

REALLY!?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!