+ Reply to Thread
Results 1 to 5 of 5

World Cup bracket help

  1. #1
    Registered User
    Join Date
    06-01-2006
    Posts
    1

    World Cup bracket help

    hey everyone, i am pretty clueless when it comes to excel so I hope this question makes sense or is possible

    I am making an excel spreadsheet for the upcoming World Cup and have a question...is it possible to have the text someone enters in a cell show up in a completely different cell?

    for instance, players will pick two teams to advance from each group...say they put Mexico in cell D4....can the word Mexico automatically show up in a different cell from a forumla, say J9? so if someone different entered USA, then in their bracket USA would end up in that cell...

    make sense?

  2. #2
    Registered User
    Join Date
    04-18-2006
    Posts
    34
    Quote Originally Posted by upper90
    hey everyone, i am pretty clueless when it comes to excel so I hope this question makes sense or is possible

    I am making an excel spreadsheet for the upcoming World Cup and have a question...is it possible to have the text someone enters in a cell show up in a completely different cell?

    for instance, players will pick two teams to advance from each group...say they put Mexico in cell D4....can the word Mexico automatically show up in a different cell from a forumla, say J9? so if someone different entered USA, then in their bracket USA would end up in that cell...

    make sense?
    Entirely... Simply type =D4 in cell J9. Note that if you add parentheses Excel will consider this a formula and will return a value of 0 for any non-value content.

  3. #3
    David Biddulph
    Guest

    Re: World Cup bracket help

    "ArenaNinja" <[email protected]> wrote
    in message news:[email protected]...
    >
    > upper90 Wrote:
    >> hey everyone, i am pretty clueless when it comes to excel so I hope this
    >> question makes sense or is possible
    >>
    >> I am making an excel spreadsheet for the upcoming World Cup and have a
    >> question...is it possible to have the text someone enters in a cell
    >> show up in a completely different cell?
    >>
    >> for instance, players will pick two teams to advance from each
    >> group...say they put Mexico in cell D4....can the word Mexico
    >> automatically show up in a different cell from a forumla, say J9? so
    >> if someone different entered USA, then in their bracket USA would end
    >> up in that cell...
    >>
    >> make sense?


    > Entirely... Simply type =D4 in cell J9. Note that if you add
    > parentheses Excel will consider this a formula and will return a value
    > of 0 for any non-value content.


    And in what way is that different from what happens without the parentheses?

    If you want the result blank until there's an entry in the cell, try
    =IF(D4="","",D4)
    --
    David Biddulph



  4. #4
    Registered User
    Join Date
    04-18-2006
    Posts
    34
    Quote Originally Posted by David Biddulph
    "ArenaNinja" <[email protected]> wrote
    in message news:[email protected]...
    >
    > upper90 Wrote:
    >> hey everyone, i am pretty clueless when it comes to excel so I hope this
    >> question makes sense or is possible
    >>
    >> I am making an excel spreadsheet for the upcoming World Cup and have a
    >> question...is it possible to have the text someone enters in a cell
    >> show up in a completely different cell?
    >>
    >> for instance, players will pick two teams to advance from each
    >> group...say they put Mexico in cell D4....can the word Mexico
    >> automatically show up in a different cell from a forumla, say J9? so
    >> if someone different entered USA, then in their bracket USA would end
    >> up in that cell...
    >>
    >> make sense?


    > Entirely... Simply type =D4 in cell J9. Note that if you add
    > parentheses Excel will consider this a formula and will return a value
    > of 0 for any non-value content.


    And in what way is that different from what happens without the parentheses?

    If you want the result blank until there's an entry in the cell, try
    =IF(D4="","",D4)
    --
    David Biddulph
    Sorry.. I didn't explain myself well enough. I meant to say that if the value is not a numerical one but an alphanumerical one or any other type, Excel will return 0.

  5. #5
    David Biddulph
    Guest

    Re: World Cup bracket help

    "ArenaNinja" <[email protected]> wrote
    in message news:[email protected]...
    >
    > David Biddulph Wrote:
    >> "ArenaNinja" <[email protected]>
    >> wrote
    >> in message
    >> news:[email protected]...
    >> >
    >> > upper90 Wrote:
    >> >> hey everyone, i am pretty clueless when it comes to excel so I hope

    >> this
    >> >> question makes sense or is possible
    >> >>
    >> >> I am making an excel spreadsheet for the upcoming World Cup and have

    >> a
    >> >> question...is it possible to have the text someone enters in a cell
    >> >> show up in a completely different cell?
    >> >>
    >> >> for instance, players will pick two teams to advance from each
    >> >> group...say they put Mexico in cell D4....can the word Mexico
    >> >> automatically show up in a different cell from a forumla, say J9?

    >> so
    >> >> if someone different entered USA, then in their bracket USA would

    >> end
    >> >> up in that cell...
    >> >>
    >> >> make sense?

    >>
    >> > Entirely... Simply type =D4 in cell J9. Note that if you add
    >> > parentheses Excel will consider this a formula and will return a

    >> value
    >> > of 0 for any non-value content.


    >> And in what way is that different from what happens without the
    >> parentheses?


    > Sorry.. I didn't explain myself well enough. I meant to say that if the
    > value is not a numerical one but an alphanumerical one or any other
    > type, Excel will return 0.


    For me it will return the alphanumeric value from D4, whether there are
    parentheses or not.
    = D4 and =(D4) give me the same result.
    --
    David Biddulph



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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