Select the cell with that formula in it and then look in the Formula Bar...
are there curly braces like this {} around the formula? If not, then you did
something wrong. To correct it, click anywhere within the Formula Bar and
press Ctrl+Shift+Enter again (all at the same time) and see if that makes
the formula work.

--
Rick (MVP - Excel)
"dcb1" wrote in message
...
Thanks for responding and showing me the different ways to solve my
problem! While the first 5 ways you gave worked, I know I am doing
something wrong when I tried the last one =IF(OR(C8:C10=1),"Yes","No")
since it only showed "###" in cell C38. I pressed the ctrl+shift
+enter--- not sure how to get this one to work. Again, Thanks for your
help!

On Aug 23, 6:51 am, "JoeU2004" wrote:
"dcb1" wrote:
if it is not too much trouble, would you
please give me couple of different solutions.

I'm not in the habit of giving answers to tests. But what the heck!

Normal formulas (commit with Enter as usual):
1. =IF(COUNTIF(C8:C10,1)0,"Yes","No")
2. =IF(SUMIF(C8:C10,1)0,"Yes","No")
3. =IF(SUMPRODUCT(--(C8:C10=1))0,"Yes","No")
4. =IF(OR(C8=1,C9=1,C10=1),"Yes","No")
5. =IF(C8=1,"Yes",IF(C9=1,"Yes",IF(C10=1,"Yes","No")) )

Array formulas (commit with ctrl+shift+Enter, not Enter):
1. =IF(OR(C8:C10=1),"Yes","No")

None of those is specific to Excel 2007.

----- original message -----

"dcb1" wrote in message

...



I guess I need a function/formula for the following: I want cell C38
to show a "Yes" or a "No" based on cell C8, C9, or C10 having a value
of 1. It doesn't matter if more than one of these cells has a 1.
Therefore, if there is a 1, then I want cell C38 to show 'Yes'; else,
'No'. Also, show 'No' is all of the cells (C8:C10) are blank or have
a number other than 1 or any other letters/characters. Also, if it is
not too much trouble, would you please give me couple of different
solutions. I am using excel 2007. Thanks!- Hide quoted text -

- Show quoted text -