Easy one... If and or
 

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!

Easy one... If and or
 

Hi D

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

HTH. Best wishes Harald

"Darin Kramer" skrev i melding
...

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!

Easy one... If and or
 

or just a bit shorter :-)

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

--
HTH

Bob Phillips

"Harald Staff" wrote in message
...
Hi D

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

HTH. Best wishes Harald

"Darin Kramer" skrev i melding
...

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!