HI,

Try:

=IF(OR(C2=1,D2=1,E2=1,F2=1),1,"")

Hope this helps!
Jean-guy

"dmack" wrote:

Have formula =IF(C2=1,"1",IF(D2=1,"1",IF(E2=1,"1",IF(F2=1,"1")) ))
shows a result of false if the answer doesn't match. What can i do to have
the cell remain blank instead of showing false.

thanx in advance
--
thanx