Remember Me?

#1
November 24th 04, 01:53 PM
 excel novice Posts: n/a
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

#2
November 24th 04, 02:06 PM
 Jason Morin Posts: n/a

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

otherwise NOT OK
.

#3
November 24th 04, 02:12 PM
 Johannes Posts: n/a

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

#4
November 24th 04, 02:15 PM
 Alex Delamain Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM

All times are GMT +1. The time now is 05:49 AM.