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 |
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 |
All times are GMT +1. The time now is 08:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com