1


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


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

Cell B2: is connected to a price quote feed and
fluctuates in price (up and down) always
changing.

Cell C2: is a manually entered price that remains
constant (unless changed).

Based on the cell formula in cell D2 it works
well - status will change from "open" to
"filled."
Problem: However if the price in cell B2 were to move
up again the status would change back from
"filled" to "open."
Question: How do I keep 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" regardless of what happens
in cell B2 afterwards.

Thank you in advance