Excel Nfl Spreadsheet
Excel 2003 is it?
I have a spreadsheet that contains the timetable for the NFL in 2007. In the previous lists, I manually entered a team wins or loses the game and the score. Scenario: A1 contains the text "Philadelphia Eagles" B1 contains the number "30" C1 contains "Adversary" D1 contains "10" Q: Is it possible that the spreadsheet can be done to determine the winner of the game based on the scores for each game I go, and (in another set of cells) to monitor the amount of gains, losses, ties, points for points against, and winning percentage? This calendar is my ambitious to date, thanks for your help. I'm not educated in algebra or calculus and I think that might need one of them for that purpose. Thank you.
Use the formula: = IF (B1> D1, "Win", "loss") You can use the "COUNT" In determining the amount of profits, losses, or ties. Indeed, it is not necessary Calcuus here. Only a few basic algebra help. Read the help of "YES" and "COUNTA functions. You will be able to do it yourself project. Try changing the "loss" in the formula to integrate "Tie." with a nested "YES." It's not that hard. All the best!
Gano Excel News Clip – Nick Lowery & Andreana Daniels
