I Need help figuring out a sports formula

B

Bigredno8

OK,I have managed to figure out a few sports formulas,like QB
Ratings,winning pct & batting avgs,but there is a formula I cant figure
out how to do.It has to do with Standings,its the Games Behind First I
need to figure out,what I need for it to work is this

W L PCT GB
(Team 1) 5 - 0 1.000 - -
(Team 2) 4 - 1 .800 1.0
(Team 3) 4 - 2 .667 1.5

Subtract Team 1 losses from Team 2 which equals 1
Subtract Team 2 Wins from Team 1 which equals 1
since both numbers are the same it should stay at 1 or 1.0

Now
Subtract Team 1 losses from Team 3 which equals 2
Subtract Team 3 Wins from Team 1 which equals 1
since both numbers are different I need them added then divided by 2
and it will then come up with 1.5

what formula can I use,which will say if the numbers are equal, that is
the answer but if they are different, added them and divide by 2
 
B

Bigredno8

Nevermind,I got it figured out tried a little spacing between things an
it managed to fix the problem

sorr
 

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

Working with sports W-L records without Excel assuming I want dates... 0
League standings based off final scores 5
Figuring out a lengthy formula. Probably quite simple... 3
Excel formula help (Need to do a rank based on 2 criteria) 4
HELP!!! I need to make a simple formula! 6
Trouble with a Formula I need help with??? 7
Sports Tipping Formula! 1
How do I have a second table pull info from the first table? 3

Top