Hello

Is their a way for the IF statement to stop calculating once one of
the conditions has been reached?

For example

A B C D
1 Symbol: Last: Limit: Status:
2 IBM-US 105.28 105 open


Cell D2 =IF(C2<=B2,"filled","open")

Is there a way from keeping the status from changing back
from "filled" to "open." In other words the
status can only go from "open" to "filled" and
remained as "filled" once the condition is met regardless of what
happens to either cells B2 or C2 afterwards.

Thank you

Mike