Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JJN
 
Posts: n/a
Default 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,???)

  #2   Report Post  
Posted to microsoft.public.excel.misc
EdMac
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson
 
Posts: n/a
Default 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,???)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return an empty cell Mike D. Excel Discussion (Misc queries) 2 January 3rd 06 07:27 PM
How do I make a cell appear empty when the formula = 0? t1202 Excel Discussion (Misc queries) 5 May 21st 05 12:18 AM
Is there a way to go to next empty cell in a formula Hopeful Exel User Excel Worksheet Functions 0 April 19th 05 11:53 PM
Formula to return ADDRESS of cell in range that meets criteria Christie Excel Worksheet Functions 1 March 5th 05 12:13 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 10:59 AM


All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"