| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zero Values
I have a simple formula that inserts a value in a cell from one spreadsheet
into the cell of another spreadsheet. If the source cell doesn't have a value, the destination cell has a zero in the cell. I would like to display a blank if the source cell doesn't contain a value - any ideas? Paul C. Peterson |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero Values
=if(a1 = "", "", a1)
-- HTH... Jim Thomlinson "Paul Peterson - Velox Consulting, LLC" wrote: I have a simple formula that inserts a value in a cell from one spreadsheet into the cell of another spreadsheet. If the source cell doesn't have a value, the destination cell has a zero in the cell. I would like to display a blank if the source cell doesn't contain a value - any ideas? Paul C. Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero Values
Instead of something like =Sheet1!A1 use =IF(Sheet1!A1="","",Sheet1!A1) This says that if Sheet1!A1 is empty, return an empty string; otherwise, return Sheet1!A1. Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Mon, 26 Apr 2010 14:10:01 -0700, Paul Peterson - Velox Consulting, LLC oft.com wrote: I have a simple formula that inserts a value in a cell from one spreadsheet into the cell of another spreadsheet. If the source cell doesn't have a value, the destination cell has a zero in the cell. I would like to display a blank if the source cell doesn't contain a value - any ideas? Paul C. Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
