IF OR AND

[SJHA360]

I have written pretty complex formulas in Excel for years, but this fairly simple IF statement has me stumped. I have written this every way I know, but it does not return the correct result. This is the original formula =IF(OR(E54>=5321,E54<=5327,E54>=5731,E54<=5738),"EVENT","REGULAR") What happens is the cell in E54=5321, so "Event" is returned correctly, however the cell in E53=5150, but still returns "Event", which is not correct. It should return "Regular"???

signed At Wits End

 

[hagia_sofia]

Hello, please test this:

=IF(OR(AND(E54>=5321,E54<=5327),AND(E54>=5731,E54<=5738)),"EVENT","REGULAR")

 

[6StringJazzer]

hagia_sofia most likely has figured out the right answer here, which is admirable, lacking a description of what the formula is supposed to do.

When you string together several conditions in an OR, the result is TRUE if any of those conditions is TRUE. In the original formula, every number is either >=5321 or <=5327 so the result will always be TRUE for any number at all.

 

[SJHA360]

Hello, please test this:

=IF(OR(AND(E54>=5321,E54<=5327),AND(E54>=5731,E54<=5738)),"EVENT","REGULAR")

It worked!!! Thank you so much, I thought I had already tried it this but evidently I did not. You are a life saver - meaning my own!

 

[Joe4]

Please note:

When marking a reply as the solution, please mark the original post containing the solution, not your own post acknowledging that some other post is the solution.
I have updated this thread for you.