Remove false from formula response in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
dmack said:
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
Click to expand...

=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 "".
 
Back
Top