<div>
=if(and(A1=&quot;abcd&quot;,or(b1=&quot;b<wbr />lue&quot;,b2=&quot;y<wbr />ellow&quot;)),9<wbr />9,0)
</div>


=if(and(A1="abcd",or(b1="blue",b2="yellow")),99,0)

<div>
Thanks Saqib<br />
If I wanted to return 99 if A1 =abcd and B1 &lt;&gt;&nbsp;blue &nbsp;OR &nbsp; B1 &lt;&gt;&nbsp;yellow<br />
how would the formula look ?<br />
* no B2 cell this time.
</div>


Thanks Saqib
If I wanted to return 99 if A1 =abcd and B1 <> blue  OR   B1 <> yellow
how would the formula look ?
* no B2 cell this time.

<div>
Just change b2 to b1<br />
<br />
=if(and(A1=&quot;abcd&quot;,or(b1=&quot;b<wbr />lue&quot;,b1=&quot;y<wbr />ellow&quot;)),9<wbr />9,0)
</div>


Just change b2 to b1

=if(and(A1="abcd",or(b1="blue",b1="yellow")),99,0)

retired

Ian Bell

<div>
I was wanting it to return 99 only if b1 did not contain &quot;blue&quot; or &quot;yellow&quot; and zero if contained blue or yellow........ A1 should always be abcd
</div>


I was wanting it to return 99 only if b1 did not contain "blue" or "yellow" and zero if contained blue or yellow........ A1 should always be abcd

<div>
I did change the question from = to &lt;&gt;&nbsp;so apologies for that.<br />
Thanks to both of you.<br />
Ian
</div>


I did change the question from = to <> so apologies for that.
Thanks to both of you.
Ian

<div>
I was trying to place the OR function and that is where I got into a mess.
</div>


I was trying to place the OR function and that is where I got into a mess.

<div>
You're welcome Ian. Glad it worked as desired in the end. :)
</div>


You're welcome Ian. Glad it worked as desired in the end. :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
Can you please help with AND/OR function<br />
LOGIC<br />
IF A1 = abcd &nbsp;AND B1 = blue &nbsp;then 99<br />
OR<br />
IF A1 = abcd AND B2 = yellow then 99<br />
otherwise zero &nbsp;<br />
Many thanks<br />
Ian
</div>
</div>


Hi,
Can you please help with AND/OR function
LOGIC
IF A1 = abcd  AND B1 = blue  then 99
OR
IF A1 = abcd AND B2 = yellow then 99
otherwise zero  
Many thanks
Ian

AND/OR FUNCTION

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.