Function
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 -
|