After you enable iterative calculations (Excel Options | Formulas |
Calculation Options | check the Enable iterative calculations checkbox)
this works - but the values in B and C have to be set before you paste
the formula into D

=IF(D4="Filled","Filled",IF(C4<=B4,"Filled","Open" ))

if a simple 'less than' rather than a 'less than or equal to' would
work, you could paste this formula into rows where the C and D cells
were blank.

In either case, when a cell refers to its own value, you are setting up
a circular calculation and the iterative calculation setting has to be
enabled.

Hope this really works the way you are expecting it to...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=114686