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

Yes. Just remore the space between your double quotes.
--
Gary''s Student


"JC" wrote:

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

You can't leave the cell blank--it's always gonna contain that formula.

The closest you can do is return a string that looks blank (""--like Gary's
Student suggested).

But you may want something else. It depends on what that other formula is.

Or maybe you should adjust that other formula.

Difficult to say without knowing that other formula.

JC wrote:

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

--

Dave Peterson