IF, AND Logical statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I write a logical IF, AND statement in EXCEL and have a result other than True or False? If so, how? Thanks
 
very unsure of what you mean by having results other than true or false?
if you mean that you want something to happen and you don't want the words
True or False to appear then you put what you want to happen in the 2nd &
3rd parameter of the IF statement

e.g.
=IF(AND(A1="cat",B1="dog"),"cat and dog found","cat and dog not found")
with return either the string "cat and dog found" or "cat and dog not found"
depending on whether the criteria was met or not.

Hope this helps
If not please post back with a specific example of what you'ld like to see
happen (please don't attach any workbooks).

Cheers
JulieD


sportsmachine said:
Can I write a logical IF, AND statement in EXCEL and have a result other
Click to expand...
than True or False? If so, how? Thanks
 
An example ...

=IF(AND(A1=20,B1=40),"A1 and B1 as expected","A1 and/or B1 not as expected")

Is this what you meant ?

Regards

Trevor
sportsmachine said:
Can I write a logical IF, AND statement in EXCEL and have a result other
Click to expand...
than True or False? If so, how? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MATCH not working in IF statement 6
How can I test the text content of a cell 4
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
How do you assess the state of a form-checkbox in a logic statemen 1
Logical test in IF statement returning incorrect result 3
if statement 5
Excel 2010 If Then logic - with time 2
Double if statement 1

Back
Top