27th August 2006, 12:44 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Crackone
Need a formula
How do I get exel to show the place odds from a fixed price e.g $3.70
I now the odds are 1/4 (0.93) but how do I display that figure in $$ terms
cheers
|
=DOLLAR(A1/4,2)
If that's not what you want then restate your question. |