New Posts For Thread: Whats your fav Excel user-defined function?https://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-functionFunction bfBakWin(Pos, bfSP, Optional IDref As String) bfBakWin = -1 If bfSP = 0 Then bfBakWin = 0: Exit Function If Pos = 1 Then bfBakWin = XUstk(Round(((bfSP - 1) * RedFact(IDref)) * CommNet, 2)) End IfEnd FunctionFor me.That's how I got started, bought myself a ZX81 and there was nothing else to do on it but learn to program. Upgraded to a ZX Spectrum but then my willy got bigger and women were more appealing than computers Tried several times in the past to get bachttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551226583#551226583That's how I got started, bought myself a ZX81 and there was nothing else to do on it but learn to program. Upgraded to a ZX Spectrum but then my willy got bigger and women were more appealing than computers Tried several times in the past to get bacSun, 19 Feb 2017 11:40:57 -0600I've got a question time function:if x=1, blame Brexit, Trump, Racism, Hitler, Fascism, Islamophobia and Bankers = round of applause.End functionhttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551226571#551226571I've got a question time function:if x=1, blame Brexit, Trump, Racism, Hitler, Fascism, Islamophobia and Bankers = round of applause.End functionSun, 19 Feb 2017 11:39:40 -0600Ovalman, GL with that.Many, many years ago I bought a home computer and was learning to write in BASIC.I wrote a dice game programme with automatic scoring for each player for the kids. I wrote little modules and kept testing them.I then put them alhttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551225961#551225961Ovalman, GL with that.Many, many years ago I bought a home computer and was learning to write in BASIC.I wrote a dice game programme with automatic scoring for each player for the kids. I wrote little modules and kept testing them.I then put them alSun, 19 Feb 2017 10:29:39 -0600I'm developing a few Android apps atm so these things interest me. I always meant to learn excel but it's on the back burner as I get to grips with Java.If you learn one language, all the rest seem to fall into place imo.https://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551225479#551225479I'm developing a few Android apps atm so these things interest me. I always meant to learn excel but it's on the back burner as I get to grips with Java.If you learn one language, all the rest seem to fall into place imo.Sun, 19 Feb 2017 09:57:03 -0600Ovalman.18 Feb 17 19:05Joined: 29 Nov 02| Topic/replies: 14,009 | Blogger: Ovalman.'s blogNo experience of ExcelWhat does if(cell="w",((cell-1)*-100),100) mean.I keep a spreadsheet to capture my history. Each row shows whether the selection won (w)https://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551223617#551223617Ovalman.18 Feb 17 19:05Joined: 29 Nov 02| Topic/replies: 14,009 | Blogger: Ovalman.'s blogNo experience of ExcelWhat does if(cell="w",((cell-1)*-100),100) mean.I keep a spreadsheet to capture my history. Each row shows whether the selection won (w)Sun, 19 Feb 2017 06:28:20 -0600Should have been:Function bfBakWin(Pos, bfSP, Optional IDref As String) bfBakWin = XUstk(-1) If bfSP = 0 Then bfBakWin = 0: Exit Function If Pos = 1 Then bfBakWin = XUstk(Round(((bfSP - 1) * RedFact(IDref)) * CommNet, 2)) End IfEndhttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551220783#551220783Should have been:Function bfBakWin(Pos, bfSP, Optional IDref As String) bfBakWin = XUstk(-1) If bfSP = 0 Then bfBakWin = 0: Exit Function If Pos = 1 Then bfBakWin = XUstk(Round(((bfSP - 1) * RedFact(IDref)) * CommNet, 2)) End IfEndSat, 18 Feb 2017 16:17:14 -0600No experience of ExcelWhat does if(cell="w",((cell-1)*-100),100) mean.https://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551219069#551219069No experience of ExcelWhat does if(cell="w",((cell-1)*-100),100) mean.Sat, 18 Feb 2017 13:05:47 -0600The = is to test equals, as it's basic.The : AFAIK joins up everything to the right of his Then, so both are done. In english: "set as zero and then exit".Condition THAT! *drops mic and walks off*https://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551219051#551219051The = is to test equals, as it's basic.The : AFAIK joins up everything to the right of his Then, so both are done. In english: "set as zero and then exit".Condition THAT! *drops mic and walks off*Sat, 18 Feb 2017 13:01:23 -0600I don't know excel but if statements should have conditions If bfSP = 0 Then bfBakWin = 0: Exit Function If Pos = 1 ThenYours has no conditionshttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551217539#551217539I don't know excel but if statements should have conditions If bfSP = 0 Then bfBakWin = 0: Exit Function If Pos = 1 ThenYours has no conditionsSat, 18 Feb 2017 09:54:23 -0600Ovalman,it works for me, but I'm not gonna tell you which ones to layhttps://community.betfair.com/chit_chat/go/thread/view/94038/30823719/whats-your-fav-excel-user-defined-function?post_id=551217181#551217181Ovalman,it works for me, but I'm not gonna tell you which ones to laySat, 18 Feb 2017 09:29:17 -0600