is there an AND logical ?

[0nanman]

i want to check multiple cells with something like:

IF CellA=1 AND IF CellB=CellC,1

 

[Don Guillett]

Perhaps a search in the HELP index for
AND
would be of assistance

 

[Don Guillett]

Perhaps a search in the HELP index for
AND
would be of assistance

 

[Jacob Skaria]

Try this with cell A1, B1 and C1

=IF(AND(A1=1,B1=C1),1,"")

 

[Jacob Skaria]

Try this with cell A1, B1 and C1

=IF(AND(A1=1,B1=C1),1,"")

 

[T. Valko]

Try this:

=--AND(A1=1,B1=C1)

 

[T. Valko]

Try this:

=--AND(A1=1,B1=C1)

 

[Glenn]

Perhaps a search in the HELP index for
AND
would be of assistance

I always used to think that, but in Excel 2003 if you select "Offline Help" and
search for:

and
AND

you get nothing. And if you try:

AND Worksheet Function

you get a whole bunch of "worksheet functions", including "RAND worksheet
function", but no "AND worksheet function". But if you search for:

logic
logical

you will find "AND worksheet function".

 

[Glenn]

Perhaps a search in the HELP index for
AND
would be of assistance

I always used to think that, but in Excel 2003 if you select "Offline Help" and
search for:

and
AND

you get nothing. And if you try:

AND Worksheet Function

you get a whole bunch of "worksheet functions", including "RAND worksheet
function", but no "AND worksheet function". But if you search for:

logic
logical

you will find "AND worksheet function".

 

[Don Guillett]

How about the little
"type a question for help" on the menu bar.

 

[Don Guillett]

How about the little
"type a question for help" on the menu bar.

 

[Rick Rothstein]

When I type AND into the search field in my copy of XL2003 (SP3 in case that
matters), the 2nd returned link is for the AND function.

 

[Rick Rothstein]

When I type AND into the search field in my copy of XL2003 (SP3 in case that
matters), the 2nd returned link is for the AND function.