Prev: #REF errors in links
Next: Adding values that fall between 2 dates
From: Wally on 23 Feb 2010 13:47
How do i use "AND" in an if statement on Excel worksheet?
From: Eduardo on 23 Feb 2010 13:51
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")

"Wally" wrote:

> How do i use "AND" in an if statement on Excel worksheet?
From: Pete_UK on 23 Feb 2010 13:54
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

On Feb 23, 6:47 pm, Wally <Wa...(a)discussions.microsoft.com> wrote:
> How do i use "AND" in an if statement on Excel worksheet?

 | 
Pages: 1
Prev: #REF errors in links
Next: Adding values that fall between 2 dates