# Linked Questions

22 questions linked to/from Display Blank when Referencing Blank Cell in Excel 2010

**3**

votes

**2**answers

57k views

### How do I prevent vlookup returning 0 for values that are blank in the lookup data? [duplicate]

My vlookup call in an Excel 2010 spreadsheet is returning a value of 0 for values that are blank in the lookup data.
How can I force vlookup to return a blank when the data is blank, and 0 when the ...

**0**

votes

**3**answers

62k views

### excel 2013 leave cell blank if it has no data [duplicate]

Maybe someone can help. I am using a simple formula where data in C is multiplied by 15 and the answer appears in D, but I want D blank until the number is entered into C.

**0**

votes

**1**answer

291 views

### Excel IF Statement identify when cell has contents [duplicate]

How do I tell MS Excel to use the contents from one cell if data exists (this data can be positive negative or zero). If the data does not exist in said cell, use contents from another cell?

**0**

votes

**2**answers

139 views

### How to keep cell blank until date entered [duplicate]

So basically, "INVOICE DUE DATE" is the SUM of D11+7 ("Date invoice sent out" + 7 days as this is when the invoice is due). However, when there is no date inputted in "DATE INVOICE SENT OUT" the "...

**9**

votes

**5**answers

2k views

### Looking for solution to shorten an IF formula

I have a long formula with the following structure:
=IF(!X!<>0,!X!+A1,"")
where !X! is a very long formula.
Is there any solution to avoid repeating the !X! twice?
I need it for two reasons:
...

**6**

votes

**3**answers

66k views

### Only show a formula result if it meets given criteria

I like to keep my Excel spreadsheets fairly clean. So, often times I'll end up writing statements like this:
IF([formula x]=[value],"",[formula x])
What that essentially says is that if the formula ...

**4**

votes

**1**answer

8k views

### Turn one row into multiple rows in Excel

I have multiple items that are available in multiple distribution centers (i.e., a many-to-many relationship). There is currently one row per item, with one column for each distribution center. A cell ...

**1**

vote

**1**answer

9k views

### EXCEL - EXTRACTING Data From Multiple Worksheets where the layout is varied

I have a spreadsheet which contains Bill of material data and Labor costs for manufactured parts.
The first worksheet contains the master part numbers for the assemblies
Each Worksheet represents the ...

**0**

votes

**1**answer

4k views

### Display 0 as blank in a pivot table

How can i display a value of 0 as blank in a pivot table. The column I wish to apply this to is formatted as a date. And anything with a value 0 displays as 00/01/1900.
I tried conditional formatting ...

**2**

votes

**2**answers

444 views

### One column data into database table format

I have data in an Excel worksheet in a single column like the following:
[Name]
[Company]
"EMAIL" (HYPERLINK)
[Name]
[Company]
"EMAIL" (HYPERLINK)
[Phone]
[Name]
...
Most people don't have phone ...

**1**

vote

**3**answers

960 views

### Need a zero in excel only when data is entered

I have a worksheet I'm working on that I need the zero to appear in the cell only when data is entered into the worksheet. When there is no data I want the cell left blank. Is this possible and if ...

**0**

votes

**1**answer

668 views

### Want to return blank cell if any cell in the range has a numeric value

I’m getting #VALUE errors because there are blank cells. Is there a way get rid of this?
Also is there a way I can make it so that any numeric value in the range of cells will return ""?
=IF((B2:G2)...

**3**

votes

**2**answers

251 views

### Non-intersecting values in columns in Excel

I have three columns with values (A, B, C) as shown below. I would like a formula in column D that will return ALL the values from column B that are not listed in column A. Similarly, what formula ...

**0**

votes

**2**answers

135 views

### How do I get nothing to print when using ISBLANK nested formulas?

I have 6 columns and 3 equations : E*F=G, H*G=I & G+I=J
I don't want zeros to print if a cell in F or H is empty.
Currently I have these equations and everything is dependent on the F & H ...

**3**

votes

**2**answers

127 views

### How can I select data and draw chart using a button in Excel?

In my Excel workbook (i.e., file),
I have for example seven sheets (Mon, Tue ... Sun) of temperatures.
This data is recorded for the whole day in a fixed frequency.
Now I want to create a tool to ...