Easy one... If and or

[Darin Kramer]

Cant seem to get my forumlae to work...

Cell A1 through G1 either has a "yes" or a "no" in it
I Need to display in cell H1 ANY instance of a no, ie if any cell shows
a no, then show no in cell h1... If and or i think, but brackets dont
want to co-operate..

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Harald Staff]

Hi D

=IF(COUNTIF(A1:G1;"No")>0;"No";"Go for it")

HTH. Best wishes Harald

 

[Bob Phillips]

or just a bit shorter

=IF(COUNTIF(A1:G1;"No");"No";"Go for it")