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. |
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 |