Would someone with experience with Excel 2000 help me to construct a complicated formula?

Question

I am developing a spreadsheet that keeps track of the NFL standings. The formula that I need help with requires that it shows the result of the winning percentage, including games that end in a tie, divided by the total games played. I have been assigning a value of 1for wins, and 0.5 for ties but cannot get it to work in a single formula.

My baseball spreadsheets are easy to formulate because there are games played divided into games won. But in football, there is that 3rd value that I've been unable to incorporate successfully.

I know there are smart people out there who are better at the algebra than I am. I can really use the help. Thank you all in advance.

Answer 1

Assuming a1 contains the number of games won, a2 the number of ties and a3 the number of losses, then your percentage is (a1 + .5*a2)/(a1 + a2 + a3)

Answer 2

i can't exactly understand what is ur problem. i may be able to help u if i see ur codes or programming.



u can send the part of the codes, which u have problem with, to me and i will look at them.



if u are not using the vba (visual basic) , i recommend u to use it because it is more powerfull than the formulas in excel.



u can also creat a formula by visual basic in excel.

Answer 3

Assuming that cell B1 is "Win", "Tie" or Blank (or any other word)



=IF(B1="Win",1,IF(B1="Tie",0.5

,0))