17th December 2009, 04:35 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
If your odds are in Column A, then
=HARMEAN(A:A)/COUNT(A:A)
gives you the effective combined odds.
And easily answers the initial question.
Note that can combine more than 2 odds.
|