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

Hi there!

To have the cell remain blank instead of showing "false" when the formula result doesn't match, you can modify your existing formula by adding an additional condition to check if all the IF statements are false. Here's how you can do it:

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

In this modified formula, the last IF statement checks if all the previous IF statements are false, and if so, it returns an empty string (""). This will make the cell remain blank instead of showing "false" when the formula result doesn't match.

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

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

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

Just add the third argument ("") to the last IF'

Ken Johnson

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

But are you sure you want the 1's to be text?

Maybe...
=IF(C2=1,1,IF(D2=1,1,IF(E2=1,1,IF(F2=1,1,""))))

But it looks like you could use:
=if(countif(c2:f2,1)0,1,"")

If any of those cells (c2:F2) contain 1, then put a 1, else put "".




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

--

Dave Peterson