in Excel, how can I assign NULL to a cell without using VBA?

My formula is:
=if(A1="Joe","It's him!","")

Open in new window


If A1 is not Joe, I want the cell to contain nothing at all, null, as if I did a clear contents on it.

How can I do that WITHOUT using VBA?  I just want to do it in the formula.
cashonlyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NorieConnect With a Mentor VBA ExpertCommented:
You can't do it with a formula.

Is the cell not being empty causing problems elsewhere?
0
 
Saqib Husain, SyedEngineerCommented:
You cannot. Formula means that there is something in the cell and it cannot be the same as a clearcontent.
0
 
cashonlyAuthor Commented:
I just want to be able to use the End DownArrow functionality to get to the next populated cell.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
NorieVBA ExpertCommented:
A cell with a formula is populated.

Have you copied the formula down to far, past the data?

Is there an adjacent column you could find the end of and then move across?
0
 
cashonlyAuthor Commented:
I've copied the formula down a column, not past the data.  I'm just using the fact that the cell has a value in it to indicate something to me and I would like to go to each subsequent instance of a cell without data.  I know I could use a filter to show only the cells with the text in them, but I want to be able to see the rows inbetween.
0
 
Saqib Husain, SyedEngineerCommented:
What you are trying to do cannot be done without the help of VBA
0
 
cashonlyAuthor Commented:
Can't be done.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.