Hello.
Does Excel 2007 have any new way to handle odds? 7/2, 12/5 etc., I would like to keep as these 'fractions' but to
be able to use them in calculations. Excel has a tendency to reduce them.
Thanks, Andy.
Betting odds
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Betting odds
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 12618
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Betting odds
You could just store the two numbers in adjacent cells, appropriately formatted, and then use them both in your calculation
StuartR
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Betting odds
Thank you. Andy.StuartR wrote:You could just store the two numbers in adjacent cells, appropriately formatted, and then use them both in your calculation
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.