New Posts For Thread: Excel Help Pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-pleaseHi allFormula in cell is=100/(W1013/W1033*100)what I want is, if the number in this cell is less than 350, I want to nomber to be 0 (zero)tiaGGRSpot onThanks again.https://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929130#420929130Spot onThanks again.Mon, 29 Mar 2010 10:16:08 -0500Many thanks will give it a gohttps://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929114#420929114Many thanks will give it a goMon, 29 Mar 2010 10:09:50 -0500Right, this should do that:In cell x970=if(w970islessthansign301,0,w970)https://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929110#420929110Right, this should do that:In cell x970=if(w970islessthansign301,0,w970)Mon, 29 Mar 2010 10:03:30 -0500In cell x970=if(w970islessthansign301,0,"")What do you want x970 to be if w970 is greater than 301? In the above example it will be blank.Thanks SMThe numbers in both cells are the same so I want the number to stay the same in w970https://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929102#420929102In cell x970=if(w970islessthansign301,0,"")What do you want x970 to be if w970 is greater than 301? In the above example it will be blank.Thanks SMThe numbers in both cells are the same so I want the number to stay the same in w970Mon, 29 Mar 2010 10:00:57 -0500In cell x970=if(w970islessthansign301,0,"")What do you want x970 to be if w970 is greater than 301? In the above example it will be blank.https://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929098#420929098In cell x970=if(w970islessthansign301,0,"")What do you want x970 to be if w970 is greater than 301? In the above example it will be blank.Mon, 29 Mar 2010 09:47:55 -0500Got a simpler one for youtiaif cell w970 is less than 301, cell x970 to be 0https://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929094#420929094Got a simpler one for youtiaif cell w970 is less than 301, cell x970 to be 0Mon, 29 Mar 2010 09:41:31 -0500Many thanks lori, I will give it a go.just experimenting on making my own tissuehttps://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929018#420929018Many thanks lori, I will give it a go.just experimenting on making my own tissueFri, 26 Mar 2010 05:39:47 -0500=IF(100/(W1013/W1033*100)smallerthansign350,0,100/(W1013/W1033*100))The number after the first comma is what goes in the cell if your condition (being smaller than 350, the sign for which doesn't work on betfair) is met (In this case zero). The numbehttps://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929010#420929010=IF(100/(W1013/W1033*100)smallerthansign350,0,100/(W1013/W1033*100))The number after the first comma is what goes in the cell if your condition (being smaller than 350, the sign for which doesn't work on betfair) is met (In this case zero). The numbeFri, 26 Mar 2010 05:37:26 -0500Hi allFormula in cell is=100/(W1013/W1033*100)what I want is, if the number in this cell is less than 350, I want to nomber to be 0 (zero)tiaGGRhttps://community.betfair.com/general_betting/go/thread/view/94082/23535582/excel-help-please?post_id=420929006#420929006Hi allFormula in cell is=100/(W1013/W1033*100)what I want is, if the number in this cell is less than 350, I want to nomber to be 0 (zero)tiaGGRFri, 26 Mar 2010 05:33:35 -0500