Formula Help Please
 

Code:
--------------------
$31,845 *$16,304*
$69,293 $69,858
$227,327 $229,454
$97,252 $94,231
$57,298 $57,097
2.338 *2.435 *
*16103* 14287
--------------------


When you change the 2.435 value above, it changes the value of the
16103 cell. I want to change the value in the 2.435 cell until the
value in the 16103 cell is closest to the 16304 cell value. This may or
may not require macros but can anyone please tack a wack at it and see
if you can find a solution. Thanks!


--
goodpasture
------------------------------------------------------------------------
goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898
View this thread: http://www.excelforum.com/showthread...hreadid=393906

You really need to give us the Formulas you are using, as well as the
expected results. How is 2.435 related to 16103 and 16304?

More info, please.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393906

It really doesn't matter,

I just want this cell to increment and while incrementing, it checks
the value of another cell until it is not less than another cell.

While B1 A1
C1 = C1 + .001
END

Please Help!!!


--
goodpasture
------------------------------------------------------------------------
goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898
View this thread: http://www.excelforum.com/showthread...hreadid=393906

Maybe I'm being dense here, but why don't you just enter 500 instead of
2.435? Maybe enter 13,641? As you said, "it really doesn't matter".

I'm thinking, though, that it really -does- matter. I just don't know
how they are related. You say changing the 2.435 value changes the
16103 cell. What is the formula in the 16103 cell?

Have you checked out ToolsSolver? It may be more along the lines of
what you need.

Sorry, I can't help further with the info given. Maybe someone else
can decipher your example and help you with this. Guess I've been in
the 'bad pasture'!

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393906

How about Tools | Goal Seek... ?
Set the lower cell A1 to increase to the value of B1 by changing C1. This
will set A1 & B1 equal.

As a macro...
Range("A1").GoalSeek Goal:=Range("B1").Value, ChangingCell:=Range("C1")

HTH
--
Dana DeLouis
Win XP & Office 2003


"goodpasture"
wrote in message
...

It really doesn't matter,

I just want this cell to increment and while incrementing, it checks
the value of another cell until it is not less than another cell.

While B1 A1
C1 = C1 + .001
END

Please Help!!!


--
goodpasture
------------------------------------------------------------------------
goodpasture's Profile:
http://www.excelforum.com/member.php...o&userid=23898
View this thread: http://www.excelforum.com/showthread...hreadid=393906