Greetings Everyone,
This is my first post. I have used Excel functions for sometime, but I am new to VBA programming. I mostly use Excel for electronic circuit equations and converting raw test data to useable data that can be plotted.
I have question regarding programming a hysteris function or sub. The problem is: Cell A1 is assigned a value of 0% until Cell B1 is equal to or greater than 2%. Cell A1 will remain 1% until Cell B1 is less than 1%, below this value cell A1 returns to a value of 0%.
I can't find a way to directly input an Excel function into a cell for this problem. I wrote a simple VBA sub that partially works, but just isn't cutting it.
Any assistance would be greatly appreciated.
This is my first post. I have used Excel functions for sometime, but I am new to VBA programming. I mostly use Excel for electronic circuit equations and converting raw test data to useable data that can be plotted.
I have question regarding programming a hysteris function or sub. The problem is: Cell A1 is assigned a value of 0% until Cell B1 is equal to or greater than 2%. Cell A1 will remain 1% until Cell B1 is less than 1%, below this value cell A1 returns to a value of 0%.
I can't find a way to directly input an Excel function into a cell for this problem. I wrote a simple VBA sub that partially works, but just isn't cutting it.
Any assistance would be greatly appreciated.