World Cup bracket help

[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?

 

[ArenaNinja]

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

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

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

make sense?

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

 

[David Biddulph]

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)

 

[ArenaNinja]

"ArenaNinja" <[email protected]>
wrote
in message



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)

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.

 

[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.

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