| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=Sheet1!A1 - with a blank entry!!!
Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print
sheet 2 - however sometimes cell A1 is left blank which is returning a 0 value on sheet2 - how can I have this so its left blank if no value is in sheet1 a1?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=Sheet1!A1 - with a blank entry!!!
=if(Sheet1!A1 = "", "", Sheet1!A1)
-- HTH... Jim Thomlinson "CP" wrote: Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print sheet 2 - however sometimes cell A1 is left blank which is returning a 0 value on sheet2 - how can I have this so its left blank if no value is in sheet1 a1?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=Sheet1!A1 - with a blank entry!!!
Thank you - that had become real annoying :)
"Jim Thomlinson" wrote: =if(Sheet1!A1 = "", "", Sheet1!A1) -- HTH... Jim Thomlinson "CP" wrote: Sheet1 A1 is transfered to a cell on Sheet 2 via =Sheet1!A1, I then print sheet 2 - however sometimes cell A1 is left blank which is returning a 0 value on sheet2 - how can I have this so its left blank if no value is in sheet1 a1?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
| page set up with blank rows between each entry | New Users to Excel | |||
| last non-blank column entry | Excel Discussion (Misc queries) | |||
| How to Link to the next blank row after the last entry in a column? | New Users to Excel | |||
| Count blank cells since last entry | Excel Worksheet Functions | |||
Linear Mode
