can you use and statements in excel?

1 ⤊

example:

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

2007-02-07 05:48:38 · 2 answers · asked by sean_mchugh6 3 in Computers & Internet ➔ Software

To my knowledge you would have to use an if statement within the original if statement.

If(x>y,if(x
That should work.

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

Yes
=IF(AND(TRUE,TRUE),TRUE,FALSE)

If both conditions inside AND() are true, then its true.

2007-02-07 21:33:54 · answer #2 · answered by unnga 6 · 1⤊ 0⤋