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
|