| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Way of making an object with a greater number be given a point....
Hi, I'm trying to produce a Sports League Table on Excel. Is there any way that I can make Excel recognise that when a team scores more goals, they are automatically given a win in the league table? For example, if i have Team A 5 - 0 Team B, how do I make excel give 1 win to team A in the league table? Please help me as i need it for my school work asap. Thanks, it will be much appreciated. -- petros89 ------------------------------------------------------------------------ petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645 View this thread: http://www.excelforum.com/showthread...hreadid=473344 |
|
#2
|
|||
|
|||
|
the =IF formula will do it- =IF(A1B1,1,0) with team A score in A1 and team
B score in B1, in the win column for team B, =if(B1A1,1,0) and if there is a tie, neither team will get a 1. "petros89" wrote: Hi, I'm trying to produce a Sports League Table on Excel. Is there any way that I can make Excel recognise that when a team scores more goals, they are automatically given a win in the league table? For example, if i have Team A 5 - 0 Team B, how do I make excel give 1 win to team A in the league table? Please help me as i need it for my school work asap. Thanks, it will be much appreciated. -- petros89 ------------------------------------------------------------------------ petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645 View this thread: http://www.excelforum.com/showthread...hreadid=473344 |
|
#3
|
|||
|
|||
|
Thanks for th IF formula. Although, how would I make it work if, for example i had 10 matches for team A versus team B? -- petros89 ------------------------------------------------------------------------ petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645 View this thread: http://www.excelforum.com/showthread...hreadid=473344 |
|
#4
|
|||
|
|||
|
I've tried adding 2 IF formulas in the same cell, but it doesn't work.. PLEASE help me as i need this for my ICT coursework...thanks in advance -- petros89 ------------------------------------------------------------------------ petros89's Profile: http://www.excelforum.com/member.php...o&userid=24645 View this thread: http://www.excelforum.com/showthread...hreadid=473344 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| making a number be text | Excel Worksheet Functions | |||
| Display a greater number of recently used spreadsheets on File ta. | Excel Discussion (Misc queries) | |||
| Maximum number of rows? | Excel Discussion (Misc queries) | |||
Linear Mode
