Thread: [Solved] How to set a no-display value to cells with a no-value link
View Single Post
 
Old 10-30-2011, 10:45 PM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
I noticed that you are not using now R1C1 reference style
There are 2 options, You can use this formula:
=IF(LEN(Sheet1!A4)>0;Sheet1!A4;"")
you might need to change the ";" separator to "," separator, depending on your regional settings.
Or, in excel options-complex-show options for this worksheet : uncheck the option -show a zero in cells with zero value
Reply With Quote