introduction excel training - If statement

The UK's most regular instructor-led training courses.
Training information: introduction excel training · Excel courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

If statement

Nick has attended:
Access Introduction course

by - delegate Nick bronze contributer [28 posts] (2007 Mar 19 Mon, 11:09) Reply

HI

Is it possible to build TWO criteria into an IF Statement? - i.e. if cellA = Yes, and if cellB = Yes, return Y, otherwise returnZ)

Cheers
NICK

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

Multiple IF statements in Microsoft Excel

by - trainer Rich platinum contributer [711 posts] (2007 Mar 19 Mon, 12:34) Reply

Hi Nick,

Yes it is possible, by using Excel's logical AND() function. Like this:
IF (AND(cellA="Yes", cellB="Yes"), "Y", "Z")

Syntax is:
=if(logical_test,value_if_true,value_if_false)

Hope this answers your excel question.

Regards, Rich

RE: If statement

by - delegate Caroline [3 posts] (2007 Mar 19 Mon, 12:37) Reply

Hi Nick,

Yes this is possible. In the expression below I am looking to see if cell A1 contains the value "a" AND cell B1 contains the value "b". If they are both true then it will give back yes, but if it is not true for one or the other it will come back and say no.

=if(A1="a",if(B1="b","Yes","No"),"No")

Alternatively in this case you could use and AND function:

=(if(AND(A1="a",B1="b"),"Yes","No")

An If statement can have up to 7 Ifs contained in it. Just make sure that you know how many brackets and commas you're putting in!!

I hope this has answered your question.

Regards,

Caroline

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Compare Different MS Excel Training Methods
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel's Best Kept Secret

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips