can you use the and operator in excel?

1 ⤊

can you use the and operator in excel?

example:

if (x>y && x
if so how do you do it?

2007-02-07 05:51:03 · 3 answers · asked by sean_mchugh6 3 in Computers & Internet ➔ Programming & Design

3 answers

Don't think so. Can you not just use +

2007-02-07 05:54:26 · answer #1 · answered by Anonymous · 0⤊ 0⤋

No, not that
=IF(AND((x>y),(y>z)),"yes", "no")
&& will be corrected to concatination & and show something like TRUETRUE
+ will give edition and add 1 for each true value.

2007-02-07 14:10:22 · answer #2 · answered by Mike1942f 7 · 0⤊ 0⤋

There is AND function:

if( AND(x>y,x

2007-02-07 13:59:42 · answer #3 · answered by sspade30 5 · 1⤊ 0⤋