Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with If statement
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with If statement
use the sheet's calculate event to check the cell value ... right click the
sheet tab, select View Code from the popup and paste this: Option Explicit Private Sub Worksheet_Calculate() If Range("D2") = "filled" Then Range("D2") = "filled" End Sub NOTE - this removes the formula and replaces it with the text. "mike" wrote in message ... 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 |
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) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |