frubeng
05-24-2010, 12:00 PM
I have a voltage counter with acceptable limits as below:
|A | B | C |D |
|102|95|101|=if(or(A1<B1,A1>C1), Beeper(),0)|
where i have the following function:
Function Beeper()
Beep
Beeper = "Broken Hi/LO"
End Function
Where A1 is a number that changes, B1 is the lower limit and C1 is the upper limit.
If the counter goes outside the limits, it will sound a beep. However, if it stays above the limit, it keeps beeping.
Therefore I wanted to put a check like put a 1 in cell E1 and so have D1=
if(and(or(A1<B1,A1>C1), d1=0), Beeper(),0)
and the function somethign like:
Function Beeper()
Beep
Beeper = "Broken Hi/LO"
Offset(0,1)=1
End Function
So that i only hear the sound once until i manually change cell D1 back to 0.
This new line obviously doesnt work, but I am wondring how I could do something like this?
(I dont just want to say Cell(1,5)=1 because i have multiple counter each with their limits...)
Any suggestion would be helpful, thanks in advance!!
|A | B | C |D |
|102|95|101|=if(or(A1<B1,A1>C1), Beeper(),0)|
where i have the following function:
Function Beeper()
Beep
Beeper = "Broken Hi/LO"
End Function
Where A1 is a number that changes, B1 is the lower limit and C1 is the upper limit.
If the counter goes outside the limits, it will sound a beep. However, if it stays above the limit, it keeps beeping.
Therefore I wanted to put a check like put a 1 in cell E1 and so have D1=
if(and(or(A1<B1,A1>C1), d1=0), Beeper(),0)
and the function somethign like:
Function Beeper()
Beep
Beeper = "Broken Hi/LO"
Offset(0,1)=1
End Function
So that i only hear the sound once until i manually change cell D1 back to 0.
This new line obviously doesnt work, but I am wondring how I could do something like this?
(I dont just want to say Cell(1,5)=1 because i have multiple counter each with their limits...)
Any suggestion would be helpful, thanks in advance!!