goodpasture,
Try using Tools - Goal Seek. Set cell B1 to the value you copy from A1, by
changing cell C1. After you get in cell C1 the result that brings you to a
state that A1=B1, then you can decrease C1 a bit. Also, you can format C1 to
show a number with 3 decimal digits.
I hope this helps,
yarp.

"goodpasture" wrote:


Well I was trying to be as simplistic as I can. it is a very complicated
spreadsheet. I was hoping to just look at 3 cells (A,B,C)

C is the only formula and the only action. Logically speaking I want C
to start at 0.001 (This will change the value of B). And then it needs
to look at the value of A and B. It will count up .001 and check each
time until B is not (in this case) less than A because the higher the
value in C, the lower the value in B gets.


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