Excel Formula to MySQL

[josborne]

I have a crazy Excel spreadsheet that I have finally gotten around to converting to a database. Most everything has gone well but I have on formula that I simply can't figure out how to convert.

 

The purpose of the formula is to take the sum of two columns and output a ratio in a text string that is easily readable (e.g 8:1 or 2:3).

 

The formula looks like this:

 

IF( SUM( Bet_tbl.Bet_Against ) =0, 0, (
LEFT( TEXT( SUM( Bet_tbl.Bet_For ) / SUM( Bet_tbl.Bet_Against ) , "####/####" ) , FIND(
"/", TEXT( SUM( Bet_tbl.Bet_For ) / SUM( Bet_tbl.Bet_Against ) , "####/####" ) ) -1 ) & ":" & RIGHT( TEXT( SUM( Bet_tbl.Bet_For ) / SUM( Bet_tbl.Bet_Against ) , "####/####" ) , LEN(
TEXT( SUM( Bet_tbl.Bet_For ) / SUM( Bet_tbl.Bet_Against ) , "####/####" ) ) - FIND(
"/", TEXT( SUM( Bet_tbl.Bet_For ) / SUM( Bet_tbl.Bet_Against ) , "####/####" )
)
)
)
)

 

The root of the problem is the text formatting bits (####). I have no idea how to do this in MySQL.

 

Any help would be greatly appreciated.

[fenway]

I'm sorry, I don't follow... show the current input and desired output.