Why isn't this if statement functioning correctly?!?

**rmar2011** · 07-28-2011, 02:23 PM

Alright so with these hypothetical values:
ActiveCell.Value = 0.2
LowerPt = -.1
UpperPt = .1
OldLow1 = -.005
OldHigh1 = .011

What should happen when I run the code pasted below is that the program should print
"Scrap" in the specified cell, and then ignore the other If statements because the values don't satisfy it.
But what really happens when I run it is that It prints scrap, then skips the second if statement, then runs through the third one, which makes no sense whatsoever.
I've looked for explanations on the forum but couldn't find anything similar, so I'm here again asking for a little guidance, (I know active doesn't need to be declared, but I was trying everything to get this little piece of the code to work). Anyone have any ideas?
Thanks!

Please Login or Register  to view this content.

**realniceguy5000** · 07-28-2011, 02:40 PM

Maybe something like this is what your after?

Please Login or Register  to view this content.

**rmar2011** · 07-28-2011, 02:45 PM

I was wondering how you did an elseif statement in excel... but the problem is when I replace the code with this it ends up just running through the first "scrap" statement every time which is really weird

**rmar2011** · 07-28-2011, 02:51 PM

Could it have to do with how my variables are declared maybe? When I run it through the debugger step by step one value shows up as .2 and the other shows up in quotations like "-.1" for example.

**rmar2011** · 07-29-2011, 07:05 AM

still looking for an explanation to this... if anyone can relate

**Colin Legg** · 07-29-2011, 07:25 AM

Yes, if the value the variable is holding is a string rather than a double, then that will make a big difference. The < and > operators can perform string comparisons as well as numerical comparisons. To understand the rules on this, have a read through the "Comparison Operators" topic in your VBA helpfile. What I suspect is happening is that this rule is being enforced: