Stumped by IF
 

Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value is
between 30000 and 40000 OR between 550000 and 569999. If the value falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris

Try:
=IF(OR(AND(A1=30000,A1<=50000),AND(A1=550000,A1< =569999)),"true","false")

"Riskybizniz" wrote:

Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value is
between 30000 and 40000 OR between 550000 and 569999. If the value falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris

Hi
one way:
=IF(OR(AND(A1=30000,A1<=40000),AND(A1=550000,A1< =569999)),"No
error","Error")

--
Regards
Frank Kabel
Frankfurt, Germany

"Riskybizniz" schrieb im
Newsbeitrag ...
Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value
is
between 30000 and 40000 OR between 550000 and 569999. If the value
falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris

Great!!! dare I ask one more thing? If nothing is entered there should be no
message.

thanks!!
Chris

"garfield-n-odie" wrote:

Try:
=IF(OR(AND(A1=30000,A1<=50000),AND(A1=550000,A1< =569999)),"true","false")

"Riskybizniz" wrote:

Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value is
between 30000 and 40000 OR between 550000 and 569999. If the value falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris

=IF(ISBLANK(A1),"",IF(OR(AND(A1=30000,A1<=50000), AND(A1=550000,A1<=569999)),"true","false"))

"Riskybizniz" wrote:

Great!!! dare I ask one more thing? If nothing is entered there should be no
message.

thanks!!
Chris

"garfield-n-odie" wrote:

Try:
=IF(OR(AND(A1=30000,A1<=50000),AND(A1=550000,A1< =569999)),"true","false")

"Riskybizniz" wrote:

Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value is
between 30000 and 40000 OR between 550000 and 569999. If the value falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris

Cool!

many thanks!

"garfield-n-odie" wrote:

=IF(ISBLANK(A1),"",IF(OR(AND(A1=30000,A1<=50000), AND(A1=550000,A1<=569999)),"true","false"))

"Riskybizniz" wrote:

Great!!! dare I ask one more thing? If nothing is entered there should be no
message.

thanks!!
Chris

"garfield-n-odie" wrote:

Try:
=IF(OR(AND(A1=30000,A1<=50000),AND(A1=550000,A1< =569999)),"true","false")

"Riskybizniz" wrote:

Hi, a (likely) easy problem but has me stumped.
A user can enter an article code in A1. I want to check if this value is
between 30000 and 40000 OR between 550000 and 569999. If the value falls
outside these 2 ranges A2 displays Error. I have been trying IF in
combination with OR, AND etc...

help?

kindest regards,
Chris