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!

Hi D

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

HTH. Best wishes Harald

"Darin Kramer" <[email protected]> skrev i melding
news:[email protected]...
>
> 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!

or just a bit shorter :-)

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

--
HTH

Bob Phillips

"Harald Staff" <[email protected]> wrote in message
news:[email protected]...
> Hi D
>
> =IF(COUNTIF(A1:G1;"No")>0;"No";"Go for it")
>
> HTH. Best wishes Harald
>
> "Darin Kramer" <[email protected]> skrev i melding
> news:[email protected]...
> >
> > 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!
>
>