Sorry your browser is not supported!

Just cant think at the moment so need to post this in here because i will come up with the solution only when i hit post. Not a second before, always happens.

If i randomize a number between 1 + 100
a = RND(99) + 1

How to i check that number is within a range. The AND statement doesnt work as it will only return a boolean value which to be honest i thought logically works ok for me, but it doesnt like it.

So:
If a > 0 AND < 21 ` If its more than 0 and less than 21 so therefore if the number is between 1 and 20? Am i right?

Logically wouldnt it go through each of those declarations and check it and return it with a 1 and 1 if the number was 15 say for example?

If a > 0 = is 'a' more than 0, yes, so 1
If a < 21 = is 'a' less than 21, yes, so 1
The AND statement needs both to be 1 so it is and that should work. It doesnt because i have missed something profoundly simple that i just cant think about right now. Can anyone help?

Right on schedule, the second i pressed post i knew what i had done wrong.

If a > 0 AND a < 21

Not as i put above a > 0 AND < 21
Its got no way to know what im talking about, is what under 21.

Knew postnig it on here would make me come up with the answer, happens every time.
If any mods want to delete this shockingly stupid thread then please spare me the shame and do so.

You are absolutely right!

Cheers.