Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return an empty cell | Excel Discussion (Misc queries) | |||
How do I make a cell appear empty when the formula = 0? | Excel Discussion (Misc queries) | |||
Is there a way to go to next empty cell in a formula | Excel Worksheet Functions | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |