Help Programming Limit Constraint
 

Hey All,

Just a quick question. I have a function called -IndexSim- and woul
like to set an IF statement so that it is inbetween two values
-UpperRange- and -LowerRange-. I have used the following:


VBA:
If IndexSim(Cnt) = LowerRange And IndexSim(Cnt) <= UpperRange Then

Is this correct, as I don't think it produces the outcome I want?

Please advise,

Many thanks,

Suz8

--
Suz8
-----------------------------------------------------------------------
Suz84's Profile: http://www.excelforum.com/member.php...fo&userid=3618
View this thread: http://www.excelforum.com/showthread.php?threadid=56741