Use of "AND"

[Wally]

How do i use "AND" in an if statement on Excel worksheet?

 

[Eduardo]

Hi,
when you want to meet two conditions for example
A1= 2
A2= 3

if the conditions above are true you want to result be "OK" otherwise "WRONG"

=if(and(A1=2,A2=3),"OK","WRONG")

 

[Pete_UK]

Here's an example:

=IF(AND(A1>0,B1>0),"Positive","not valid")

Both A1 and B1 have to be greater than 0 to get "positive".

Hope this helps.

Pete