Why is this equation equal to Zero and not 555?

[sleepdoc]

I have been using Excel for years. but i hate if statements and im very bad at them.

A1 is NO
A2 is NO
A3 is NO

(The "NO" is a data validation list value)

The equation reads

=IF((A1="NO" & A2="NO & A3="NO"), 555,0)

I keep getting Zero instead of 555.

Argg.

thanks for any help

 

[MARK858]

Because the way you have written it you are trying to concatenate the cells, try...

=IF(AND(A1="NO",A2="NO",A3="NO"),555,0)

 

[Ron Coderre]

You could try something like this:

=IF(COUNTIF(A1:A3,"NO")=3,555,0)

Is that something you can work with?

 

[JackDanIce]

Another suggestion:

=--(A1&A2&A3="NONONO")*555