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 |
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 |
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 |
All times are GMT +1. The time now is 05:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com