referenced cells displayed 0 when it shouldn't display anything

  • Thread starter Thread starter drewmacher
  • Start date Start date
D

drewmacher

Hello. I referenced cells from one spreadsheet to another usin
='nameOfFile'!A1 as an example, however, on this it displays 0. How d
u get rid of this? e.g. spreadsheet one called home, has A1 a
nothing. spreadsheet called away has ='home'!A1, and this displays
in the cell
 
Try this:

=IF('home'!A1="","",'home'!A1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello. I referenced cells from one spreadsheet to another using
='nameOfFile'!A1 as an example, however, on this it displays 0. How do
u get rid of this? e.g. spreadsheet one called home, has A1 as
nothing. spreadsheet called away has ='home'!A1, and this displays 0
in the cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell display 2 4
Is it possible to call an excel function indirectly? 4
#N/A Conditional Formatting affects all cells? 9
cell text not displaying into next blank cell 3
Equal "" when zero has a space after it 6
has a cell been referenced in another worksheet 3
Displaying contents of cell on different spreadsheet 1
Excel Repeating a RAND() function under certain conditions 0

Back
Top