Formula Help Please

G

goodpasture

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* 1428
-------------------


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

swatsp0p

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.
 
G

goodpasture

It really doesn't matter,

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

While B1 > A1
C1 = C1 + .001
END

Please Help!!
 
S

swatsp0p

Maybe I'm being dense here, but why don't you just enter 500 instead o
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 kno
how they are related. You say changing the 2.435 value changes th
16103 cell. What is the formula in the 16103 cell?

Have you checked out Tools>Solver? It may be more along the lines o
what you need.

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

Bruc
 
D

Dana DeLouis

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" <[email protected]>
wrote in message
news:[email protected]...
 
Top