if statements

[John]

if i want to write a statement that said "if this is true,
AND that is true, then equal X, if not, equal Y"

How would I write that?
Thank you-

 

[mangesh_yadav]

=IF(AND(this=TRUE,that=TRUE),x,y)

- Manges

 

[Don]

-----Original Message-----
if i want to write a statement that said "if this is true,
AND that is true, then equal X, if not, equal Y"

How would I write that?
Thank you-
.

Try

=if(and('this is true','that is true'),"X","Y"

 

[John]

Thanks!
is there a limit to how many If/And's you can use in this?
for example, "if a is true, b is true, and c is true,
then equal x, if not, equal y"

 

[Don]

There is a limit to nested "If's" but I've not heard of a
limit to "And" statements.....however, if I'm wrong...stay
tuned...one of the very qualified experts here will
straighten us both out.......

Don