Hello,

if you type into cell C38

=IF(OR(C6=1,C7=1,C8=1),"Yes","No")

you will get your desired affect
--
Kevin Smith :o)


"dcb1" wrote:

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!