I am using the formula, =IF(ISNUMBER(Analysis!O6),Analysis!O6," ") but have a
problem. If there is a value in Analysis!O6 then the file works properly.
However, if Analysis has no value in it, then I need to formula to return
nothing. The problem is that I can only get the formula to return a blank
space, 0, or False. All of these results cause a subsequent formula to fail.


Is there a different formula or criteria that will leave the cell empty?
--
Thanks in advance,
JC