Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

asked on

And OR formula

Hi,
I'm trying to do what should be a simple formula.
Please see attached. I have placed the formula results in column A
Please place formula in A col.
Thanks
Ian
-AND-OR.xlsx
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi,
Please try below:
=IF(OR(AND($A$1=B2,C2>5,C2<7),AND(C2>8,C2<10),AND(C2>12,C2<16),AND(C2>20,C2<30)),0,1)

Open in new window

Avatar of Ian Bell

ASKER

Cells A5:A6 result should be 1 as B5 or B6 are not equal to A1
Thanks
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Shums, perfect. I had the same formula as you had first sent, then got lost :)
Cheers
Ian
You're Welcome Ian! Glad I was able to help.