software

I want the following formula to return an empty cell. (not a cell with quot;quot;
text in it). Everything I tried to put in either gives me a quot;textquot; or quot;0quot;. or
I do have a macro that deletes the cell content, but how do you run a macro
where the ??? are.
=IF(ISBLANK(E9)=FALSE,E9,???)
Hi JJn,

I don't see what you are trying to achieve - can you explain a bit
more?

Ed--
EdMac
------------------------------------------------------------------------
EdMac's Profile: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=511037Maybe you can use:

=if(isblank(e9)=false,e9,na())

Then you can select that range (a single column)
edit|goto|special
formulas
Only errors
hit the delete key

You can record a macro if you want code.

Remember that the formula will be gone--so if E9 changes, that cell won't
update.

JJN wrote:
gt;
gt; I want the following formula to return an empty cell. (not a cell with quot;quot;
gt; text in it). Everything I tried to put in either gives me a quot;textquot; or quot;0quot;. or
gt; I do have a macro that deletes the cell content, but how do you run a macro
gt; where the ??? are.
gt; =IF(ISBLANK(E9)=FALSE,E9,???)

--

Dave Peterson

Try

=IF(ISBLANK(E9)=FALSE,E9,quot;quot;)

But it seems that you don't need the IF statement at all. You
could simply use

=E9
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;JJNquot; gt; wrote in message
...
gt;I want the following formula to return an empty cell. (not a
gt;cell with quot;quot;
gt; text in it). Everything I tried to put in either gives me a
gt; quot;textquot; or quot;0quot;. or
gt; I do have a macro that deletes the cell content, but how do you
gt; run a macro
gt; where the ??? are.
gt; =IF(ISBLANK(E9)=FALSE,E9,???)
gt;