Remove false from formula response in cell
 

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

Answer: Remove false from formula response in cell
 

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.

Remove false from formula response in cell
 

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

Remove false from formula response in cell
 

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

Remove false from formula response in cell
 

=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