Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula can you help?
Need a bit of Help! At the mo im make a simple spreadsheet to convert betting odds can do most convert's but when it comes to changing american odds to decimal or fractions i just cant think to get from fractional to american i use Fraction to Percentage [=1/(1+D6)] D6=Fraction Cell then from percentage to american =IF(D10<0.5,ROUND((100/D10)-100,0),ROUND(-100*D10/(1-D10),0)) D10=Percentage Cell i just cant get back from american to percentage Spreadsheet is attached if you need any more info email +-------------------------------------------------------------------+ |Filename: Odds Convertor.zip | |Download: http://www.excelforum.com/attachment.php?postid=4999 | +-------------------------------------------------------------------+ -- sjgidman ------------------------------------------------------------------------ sjgidman's Profile: http://www.excelforum.com/member.php...o&userid=36174 View this thread: http://www.excelforum.com/showthread...hreadid=559534 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |