Anyone have an awesome tricked out sports excel spreadsheet?

MikeyObviously · #1 02-04-2005, 01:09 PM

or something similar to that? Would you be willing to share? I am trying to make one now while I'm at work, and one to keep track of poker accounts, but I'm pretty mediocore with excel.

MikeyObviously · #2 02-04-2005, 02:29 PM

I have run into problems figuring out how to calculate the vig

tech · #3 02-04-2005, 04:15 PM

What do you want it to do?

MikeyObviously · #4 02-04-2005, 08:25 PM

Well, I want to be able to type in...say -110, and have that -110 in excel symbolically mean .909... I can't do calculations with an entry like -110, but I can in decimal form such as .909. I need a function to convert.

tech · #5 02-04-2005, 08:37 PM

If cell A1 has your price (say -110), you can use the following formula for the decimal multiplier:

=IF(A1<0,-100/A1,A1/100)

MikeyObviously · #6 02-05-2005, 05:45 AM

wow thanks