close
When I use the IF function in most cases, I want it to either show some text
or nothing at all. I have always performed this function as in the following
example:
=IF(A1=5,quot;Fivequot;,quot; quot;)
If A1 is not equal to five, then my cell will show a space which makes it
appear to look empty or blank... a cheap fix I suppose. Is there a way to
make a cell truly act as if it were completely empty in this case?... without
cheating with a quot; quot; space or without returning a zero (0)? Thanks much for
any info.
全站熱搜
留言列表
