='Sheet1'B3

  • Thread starter Thread starter Dragan
  • Start date Start date
D

Dragan

Hi,

When I use formula ='Sheet1'B3 I get result 0 if B3 is blank. How can I get
blank cell if B3 is blank?

Thanks,
Alex
 
Please note that the cell will not be blank but will have a zero length string in it. Visually this is not important but it's worth remembering if any code / formulae rely on the cell actually being blank (which is impossible if it has a formula in it)
 
Right. This issue pops up from time to time
in the Excel groups.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

xlbo said:
Please note that the cell will not be blank but will have a zero length
Click to expand...
string in it. Visually this is not important but it's worth remembering if
any code / formulae rely on the cell actually being blank (which is
impossible if it has a formula in it)
 
-----Original Message-----
Hi,

When I use formula ='Sheet1'B3 I get result 0 if B3 is blank. How can I get
blank cell if B3 is blank?

Thanks,
Alex


.Alex, I would format your cell with the formula with
Click to expand...
the "," function in your toolbar. It will show a "-"
instead of "0". Or you could use the "IF" formula where
the "value if false" is "". This will show a blank.
 
In fact the difference between something like
=SUM(A1:A3) and =A1+A2+A3
where SUM ignores text entries can be readily seen in

A1: 1
A2: ="" or a single space or anything else that is TEXT
A3: 4
A4: =SUM(A1:A3) or =SUM(A1:OFFSET(A4,-1,0)

if you use
A4: =A1+A2 +A3
you will get an error #VALUE!

Anonymous postings:
Use of a real name and a hotmail address -- that you look at for
newsgroup use would probably work a lot better for you. At the
very least it would be a lot more friendly when asking others for
help. You can set the hotmail spam filter very high but not to exclusive
email names only. Hotmail does have very good spam filtration
when set to "Enhanced -- most junk emaikl is caught" -- you set
your options from the options link next to the Help link in Hotmail.
 
Back
Top