return an EMPTY cell in an IF formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,???)
 
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.
 
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
 
Back
Top