New Posts For Thread: Excel formula help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23870250/excel-formula-help-pleaseColumn A = % chanceColumn B = 100/aIn column C i want the following:-If (a1 is more than 19.99 return b1*.9), If (a1 is between 15 and 19.99 return b1*1.1), If (a1 is between 10 and 14.99 return b1*1.5)What would be the excel formulas please? the exaNo problemhttps://community.betfair.com/general_betting/go/thread/view/94082/23870250/excel-formula-help-please?post_id=430342110#430342110No problemTue, 27 Apr 2010 06:03:39 -0500thanks Don! .. i took out the 2 commas towards the end and it works finehttps://community.betfair.com/general_betting/go/thread/view/94082/23870250/excel-formula-help-please?post_id=430342106#430342106thanks Don! .. i took out the 2 commas towards the end and it works fineTue, 27 Apr 2010 05:03:49 -0500=IF(A1>19.99,B1*0.9,IF(AND(A1>14.99,A1<20),B1*1.1,IF(AND(A1>9.99,A1<15),B1*1.5,),))https://community.betfair.com/general_betting/go/thread/view/94082/23870250/excel-formula-help-please?post_id=430342102#430342102=IF(A1>19.99,B1*0.9,IF(AND(A1>14.99,A1<20),B1*1.1,IF(AND(A1>9.99,A1<15),B1*1.5,),))Tue, 27 Apr 2010 04:59:40 -0500Column A = % chanceColumn B = 100/aIn column C i want the following:-If (a1 is more than 19.99 return b1*.9), If (a1 is between 15 and 19.99 return b1*1.1), If (a1 is between 10 and 14.99 return b1*1.5)What would be the excel formulas please? the exahttps://community.betfair.com/general_betting/go/thread/view/94082/23870250/excel-formula-help-please?post_id=430342098#430342098Column A = % chanceColumn B = 100/aIn column C i want the following:-If (a1 is more than 19.99 return b1*.9), If (a1 is between 15 and 19.99 return b1*1.1), If (a1 is between 10 and 14.99 return b1*1.5)What would be the excel formulas please? the exaTue, 27 Apr 2010 04:38:00 -0500