Thread: Stumped by IF
View Single Post
  #1   Report Post  
Riskybizniz
 
Posts: n/a
Default 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