Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Not even sure if this is the correct function for what I'm trying to do:
using live data I'm trying to create a function that checks if a certain value has been touched and in the event that it has (TRUE) it changes the cell to read e.g. "TRIGGERED". I know this can be done with the IF Function, however I want the "TRIGGERED" to remain should the function no longer be true in the future (e.g. if the value goes back below the trigger after touching it). Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Hi Endugu.
If I well understand, try: If Range("A1").value < "TRIGGERED", then .... make the test Else .... go away End If Regards Eliano "Endugu" wrote: Not even sure if this is the correct function for what I'm trying to do: using live data I'm trying to create a function that checks if a certain value has been touched and in the event that it has (TRUE) it changes the cell to read e.g. "TRIGGERED". I know this can be done with the IF Function, however I want the "TRIGGERED" to remain should the function no longer be true in the future (e.g. if the value goes back below the trigger after touching it). Thanks in advance for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
This can be easily handled by an event macro, but if you want a
worksheet function solution, one way: Choose Tools/Options/Calculation and check the Iteration checkbox. To monitor cell A1: B1: =IF(B1="Triggered",B1,IF(A1=100,"Triggered","")) In article , Endugu wrote: Not even sure if this is the correct function for what I'm trying to do: using live data I'm trying to create a function that checks if a certain value has been touched and in the event that it has (TRUE) it changes the cell to read e.g. "TRIGGERED". I know this can be done with the IF Function, however I want the "TRIGGERED" to remain should the function no longer be true in the future (e.g. if the value goes back below the trigger after touching it). Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |