Excel If Function

's Computer Specifications

Can you let me know how I write an IF formula in an
excel that will return a TRUE value in the cell D2 if the
cell A2 contains the word Alcohol and cell A2 contains
the word Drugs and cell C3 contains the word anger.

Thanks Nick Read

's Computer Specifications

One way:

D2: =AND(COUNTIF(A2,"*Alcohol*"), COUNTIF(A2,"*Drugs*"),
COUNTIF(C3,"*anger*"))

or

D2: =IF(AND(COUNTIF(A2,"*Alcohol*"), COUNTIF(A2,"*Drugs*"),
COUNTIF(C3,"*anger*")),TRUE,"")

In article <099001c55180$96dff2d0$(E-Mail Removed)>,
"Nick Read" <(E-Mail Removed)> wrote:

> Can you let me know how I write an IF formula in an
> excel that will return a TRUE value in the cell D2 if the
> cell A2 contains the word Alcohol and cell A2 contains
> the word Drugs and cell C3 contains the word anger.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy of excel file not showing formulal/function in the function b	=?Utf-8?B?b2FhbGxhbQ==?=	Microsoft Excel Misc	4	6th Sep 2007 02:20 PM
Excel - User Defined Function Error: This function takes no argume	=?Utf-8?B?QnJ1Y2VJbkNhbGdhcnk=?=	Microsoft Excel Programming	3	23rd Aug 2006 09:53 PM
Excel worksheet function - Sort of LookUp Function - Help Needed	iwtci	Microsoft Excel Worksheet Functions	1	25th May 2004 12:14 PM
Adding a custom function to the default excel function list	DonutDel	Microsoft Excel Programming	3	21st Nov 2003 04:41 PM
Re: When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel	Niek Otten	Microsoft Excel Programming	2	18th Sep 2003 04:55 AM