Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport into SQL (I know it sounds weird, but trust me, that's what we need). I only want to display cell B1 if C1 is populated, so I use the following formula in cell B1:


This works fine, but my cells have a formula in them because it's referencing my user input sheet. Cell C1 has the formula:


Even though it still has a blank "value", the formula above does not see the cell as blank and doesn't do what I need. Is there any solution for this?

Thank you kindly, Jeff

share|improve this question

I am not sure what you mean by "blank 'value'", whether that means it is actually blank or just showing as "0". But I plugged the provided information in Excel and it seems that your issue may be that C1 is showing as value "0", and so B1 is displayed? If so, you could try making C1 similar to B1:


So if there is no value in Sheet1!E23, it will show as blank in C1, which will mean B1 will not populate according to the B1 formula.

share|improve this answer
That definitely made sense. Thank you. It wasn't exactly what I was looking for, but put me on the right track. I'm using a different cell to check whether there is a value or not. Works great. Thanks so much for the help! – Jeff Jun 12 '12 at 12:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .