Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List box has me stumped. | Excel Discussion (Misc queries) | |||
Stumped! Collecting values into one cell. | Excel Worksheet Functions | |||
Stumped! Collecting values into one cell. | Excel Worksheet Functions |