Help in using 'IF' statements in Excel

[sunnyvale1]

Hi,

can someone please help me with the formulat ot use to code a if statement with and included.

Like for example if want to say (if A and B are ture display A) in an Excel worksheet. How do we do it and how to in general use a (if condition with and/or included.

Thanks in advance,

avitra

[swatsp0p]

Assuming your cells to test are A1 and B1, use this formula:

=IF(AND(A1=5,B1=10),A1,"FAIL")

therefore, if A1 contains 5 AND B1 contains 10, 5 is returned. If A1 OR B1 is anything else, the text "FAIL" is returned.

HTH

Bruce