Linked Questions

3
votes
2answers
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
3answers
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
1answer
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
2answers
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
5answers
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
1answer
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
2answers
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
2answers
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
2answers
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 ...

15 30 50 per page