ok I'll send the file
sorry when I try upload the life, it sends then I await for a number as such, then blank screen????
OK Richie try this http://ge.tt/9zhVVOd/v/0
So you need 50% of the Max of a Range Michael?
Hi Richie, The range to the left of the MAX column. It's important to note that this is NOT a static list, it's dynamic and active as its for Roulette,. So please try to understand how it should work. IF the previous spin was less than the 50% MAX, then zero. Maybe its can't work, because when its not on the same line, then it throws the whole thing out and it looses.
It cant real be on the same line as it throws the results way out!
I think you get the idea, however, one can't apply it to a single line, when you run it down it eqautes, or if it does then it does not work cause if it hits and you have a zero then its a downward spiral. I think it can't work and a different formula is needed. Being on the same line is like putting you money down as the ball drops in the socket if you know what I mean. Any suggestions on another way to tackle the issue is welcome.
After checking it appears to work, but not really, You really need to not use RAND to generate numbers, because it can appear that it works but in reality it doesn't. One has to input row by row, then you will see what I mean. I'm preparing a template that will help you understand the issue. In reality its sometimes work and sometimes not, something to do with the next row, previous row thing I thought, that's what I'm struggling with. I'll email it in an hour or so when complete.