Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- upper90 ------------------------------------------------------------------------ upper90's Profile: http://www.excelforum.com/member.php...o&userid=35025 View this thread: http://www.excelforum.com/showthread...hreadid=547664 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
World Cup bracket help
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. -- ArenaNinja ------------------------------------------------------------------------ ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624 View this thread: http://www.excelforum.com/showthread...hreadid=547664 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
World Cup bracket help
"ArenaNinja" wrote
in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
World Cup bracket help
David Biddulph Wrote: "ArenaNinja" wrote in message ... 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. -- ArenaNinja ------------------------------------------------------------------------ ArenaNinja's Profile: http://www.excelforum.com/member.php...o&userid=33624 View this thread: http://www.excelforum.com/showthread...hreadid=547664 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
World Cup bracket help
"ArenaNinja" wrote
in message ... David Biddulph Wrote: "ArenaNinja" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The world is really unstable these days...... | Excel Worksheet Functions | |||
The world is really unstable these days...... | Setting up and Configuration of Excel | |||
How can I automate a 16 man wrestling bracket in Excell. | Excel Worksheet Functions | |||
The Draw Menue "bracket" | Excel Discussion (Misc queries) |