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
 
Back
Top