Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

scubafrog79

Programmer
Oct 10, 2014
13
US
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.
 
What's the business case?

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/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!
 
Never mind I figured it out.

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

 
Do you realize how trivial?

1000000-cell+cell

REALLY!?

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top