# 0 value when linking to a blank cell

1. ## 0 value when linking to a blank cell

I am running a football scores competition. I have a sheet which will contain all the results as they occur. As yet the competition has not started so all scores are blank.
But when I link the scores to another sheet it shows as 0-0 which looks like the match has been played and the score is 0-0.
i.e. results sheet shows "Team A Team B " but the cell that links to it shows "Team A 0 Team B 0"
I have seen a work round whereby you set the cell fromat to custom and then type in 0;-0;. This is allows the cell to show blank instead of 0, but there is a problem. The cell now cannot show 0 even when a 0 is typed in to the results sheet.

2. ## Re: 0 value when linking to a blank cell

What is the formula that you are using to populate the scores on this sheet?

3. ## Re: 0 value when linking to a blank cell

Maybe this?

=if(your-formula="","",your-formula)

4. ## Re: 0 value when linking to a blank cell

No formula. there are currently no scores on the results sheet.
all the fixtures are in the results sheet. Currently blank as its next years world cup.
There is a separate sheet for each player.
So in the appropriate place on each players sheet i put =Results!B4 for example.
But whereas the cell in Results sheet is blank, the cell in the players sheet shows 0.
When results are blank in the results sheet it needs to be blank in the players sheet.
If this does not help I may be able to send my workbook or a sample.

5. ## Re: 0 value when linking to a blank cell

Thanks. I'm sure this will work but I feel sure it should be able to be done without formula.

6. ## Re: 0 value when linking to a blank cell

Try the formula in post #3. That is:

=IF(Results!B4="","",Results!B4)

Edit: Just saw your last post. You already have a formula there so i'm not sure why you don't want to simply edit the formulas.

7. ## Re: 0 value when linking to a blank cell

Originally Posted by bakert
Thanks. I'm sure this will work but I feel sure it should be able to be done without formula.
If you want to pull info from another cell (if I understand your request), other than using VBA, there is no other way to pull the into, than using a formula

8. ## Re: 0 value when linking to a blank cell

Ok thanks. Looks like I am going use the formula. I thought it should be easy as typing = then clicking in the cell I wanted to link to. I have something in the back of my mind from a tutorial where you can set a cell or range to "allow null", but can't find anything on help. It may be something only on Access DB.
Thanks for trying
Trevor.

9. ## Re: 0 value when linking to a blank cell

Originally Posted by bakert
I thought it should be easy as typing = then clicking in the cell I wanted to link to.
That is/would be a formula

set a cell or range to "allow null"
That may be access, but in excel, you can set up Data validation to only allow specific entries

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1