is it possible to check
 

Hi all,

I need help...

I would like to know how to go about an if statement to validate if a number
is between 2 numbers?

For example, an entered number then if the number is between 5 and 50,
then....something

=IF(AND(A1=5,A1<=50),"between","outside")

Regards,
KL


"leeyowh" wrote in message
...
Hi all,

I need help...

I would like to know how to go about an if statement to validate if a
number
is between 2 numbers?

For example, an entered number then if the number is between 5 and 50,
then....something