Way of making an object with a greater number be given a point....

P

petros89

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

Marvin P. Winterbottom

the =IF formula will do it- =IF(A1>B1,1,0) with team A score in A1 and team
B score in B1, in the win column for team B, =if(B1>A1,1,0) and if there is a
tie, neither team will get a 1.
 
P

petros89

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

petros89

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting up a Football League Table 1
Countif until a number occurs four times in a row then return that number 3
Finding the weighted average of text that have been given values 1
League standings based off final scores 5
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Return a value from a list in another worksheet 5
Appending a table by adding only records who are not duplicates 2
Ignoring Formulas 3

Top