I don't want blank tp equal zero

  • Thread starter Thread starter lovemark
  • Start date Start date
L

lovemark

I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in cell a1 of
sheet 1, that number appears in sheet 2. The problem is that when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually zero.
 
=if(sheet1!a1="","",sheet1!a1)


I have 2 worksheets which we will call sheet1 and sheet2.
When I write =sheet1!a1 in sheet 2, and insert a number in cell a1 of
sheet 1, that number appears in sheet 2. The problem is that when I have
it blank, I get zero in sheet 2. I can I make blank show blank?
Obviuosly I want to get zero if the number I insert is actually zero.
Click to expand...
 

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

Blank Cell Reference, without if statement 4
=Sheet1!A1 - with a blank entry!!! 4
Linking blank cells 1
Cross-Referencng numbers between worksheets 3
Returning a zero 4
=Sheet!A1 formula alternative 2
Need linked cell to be blank not 0 2
Hyperlink via indirect cell reference 8

Back
Top