Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement
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. Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Using an IF statement, or VLOOKUP statement | Excel Programming | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |