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" <JJN@discussions.microsoft.com> wrote in message
news:05DB94FC-E32F-4503-96BF-95C6544FA211@microsoft.com...
>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,???)
>