Hi,
In the attached workbook, I created some simple logic to switch between two states based on the data values in columns B and C. In column D, the logic requires that the condition be true for one data point for the switch to occur. In column E, the formula requires two consecutive samples be true for the switch.
What I really need are two things:
1) The "On" and "Off" controls have separate, independent logic
2) The number of consecutive cells which must true for the "On" and "Off" controls can be changed via a cell value; also independent.
Could anyone in the Forum help with a cell formula that could do this?
Any help would be greatly appreciated.
Thanks,
-Art
Bookmarks