Looking for help

**CadensDad** · 03-08-2005, 07:27 PM

I am looking for help with a spreadsheet I am working on. I am creating a spreadsheet for betting on sports. I cannot figure out a formula. I have worked on it for a couple weeks and am beating my head against a wall. I am willing to email the spreadsheet to someone if they are willing to look at it and have me explain what I am looking for the cell to do. If you post your email I will get it out to you asap. Thank You in advance. Oh and it will be used for amusement puposes only! Of course.

**olasa** · 03-08-2005, 07:42 PM

Please give us an example of how you like the end result to look like.
It will help in giving you the best solution.
Ola

**CadensDad** · 03-08-2005, 09:22 PM

Here is a link to my spreadsheet.

http://www.geocities.com/jaws7769/bets.xls

in the column with pick I would like to enter either over or under. I want the program to read whether I have entered over or under then look at the column with line which would be a number say 198 for example. I then want the program to look at the 2 columns under score and there of course I will have a score entered for both teams say 100 to 99. Then I would like the program to determine whether I have won or lost by going over or under the line specified which was 198. Then in the tally column it would calculate how much I have won or lost. Which would be established bythe column with times as the header. The calculation would be for a win ex. 20x5 or for a loss 20x-5.5. I have a conditional format for the tally column to either be highlighted in red for a neg number and green for a positive number. I hope this does not screw you up bigtime but it is hard to explain over the pc. Thanks again. I hope the link works.