return an EMPTY cell in an IF formula
 

I want the following formula to return an empty cell. (not a cell with ""
text in it). Everything I tried to put in either gives me a "text" or "0". 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,???)

return an EMPTY cell in an IF formula
 

Hi JJn,

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

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=511037

return an EMPTY cell in an IF formula
 

Maybe 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:

I want the following formula to return an empty cell. (not a cell with ""
text in it). Everything I tried to put in either gives me a "text" or "0". 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,???)

--

Dave Peterson

return an EMPTY cell in an IF formula
 

Try

=IF(ISBLANK(E9)=FALSE,E9,"")

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



"JJN" wrote in message
...
I want the following formula to return an empty cell. (not a
cell with ""
text in it). Everything I tried to put in either gives me a
"text" or "0". 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,???)