how to use if,and,or functions together in excel
 

I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me answer of OK,
otherwise NOT OK

Answer: how to use if,and,or functions together in excel
 

To create the formula you described, you can use the IF, AND, and OR functions together in Excel. Here are the steps:

1. Start by typing the following formula into the cell where you want the result to appear:
   
   
   Code:

   ---

   =IF(AND(X=1,OR(Y=3,Y=4,Y=5,Y=6)),"OK","NOT OK")

   ---

2. Replace "X" and "Y" with the cell references for the cells you want to check. For example, if you want to check if cell A1 equals 1 and if cell B1 equals 3, 4, 5, or 6, you would use the following formula:
   
   
   Code:

   ---

   =IF(AND(A1=1,OR(B1=3,B1=4,B1=5,B1=6)),"OK","NOT OK")

   ---

3. Press Enter to see the result. The formula will return "OK" if both conditions are met (cell X equals 1 and cell Y equals 3, 4, 5, or 6), and "NOT OK" if either condition is not met.

That's it! You can copy and paste this formula to other cells if you need to check multiple sets of data.

One way:

=IF(AND(A1=1,OR(B1={3,4,5,6})),"OK","NOT OK")

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me
answer of OK,
otherwise NOT OK
.

cell x = A1
cell y = A2

= IF( AND(A1 = 1, OR( A2 = 3, A2 = 4, A2 = 5, A2 = 6) ), "OK", "NOT OK" )

depending on configuration use semi-colon instead of colon.

JP


"excel novice" <excel schreef in bericht
...
I want to create a formula as follows
IF cell x = 1, AND cell y=3, 4, 5, OR 6, then give me answer of OK,
otherwise NOT OK

If your terms arenice and simple (e.g. value is between 3 and 6) then:
=IF(AND(A1=1,B1=3,B1<=6),"OK","Not Ok")

if there are gaps (e.g. 3,4,6 but not 5) then

=IF(AND(A1=1,OR(B1=3,B1=4,B1=5,B1=6)),"OK","Not Ok")


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=320089