Here's an example:

=IF(AND(A10,B10),"Positive","not valid")

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

Hope this helps.

Pete

On Feb 23, 6:47*pm, Wally wrote:
How do i use "AND" in an if statement on Excel worksheet?