A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Display Modes
  #1  
Old November 24th 04, 01:53 PM
excel novice
external usenet poster
 
Posts: n/a
Default 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
Ads
  #2  
Old November 24th 04, 02:06 PM
Jason Morin
external usenet poster
 
Posts: n/a
Default

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
>.
>

  #3  
Old November 24th 04, 02:12 PM
Johannes
external usenet poster
 
Posts: n/a
Default

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  
Old November 24th 04, 02:15 PM
Alex Delamain
external usenet poster
 
Posts: n/a
Default


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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM


All times are GMT +1. The time now is 11:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.