>>>>>>Iif( Mod(NUMBER_TO_REACH,1000) = 0, 1, Mod(Mod(NUMBER_TO_REACH, 1000 ),11 ) )
>>>>>
>>>>>I'm not sure, need to think. For 100, it's 1, for 200 it's 2, for 300 it's 3, etc.
>>>>
>>>>I think at after 1000 it starts all over again back at 1 again.
>>>
>>>Right, but we assumed, that number should be round, e.g. 100, 200, 300. What if it's any integer number greater than 10?
>>
>>Actually, I modified the formula to look like.
>>Iif( Mod(NUMBER_TO_REACH,1000) = 0, Mod( NUMBER_TO_REACH, MAX_CHOICE + 1 ), Mod(Mod(NUMBER_TO_REACH, 1000 ),MAX_CHOICE + 1 ) )
>>
>>It turns out that if you get back 0, the first person loses. And that's the case if Mod( NUMBER_TO_REACH, MAX_CHOICE + 1 ) = 0.
>>
>>So If
>>NUMBER_TO_REACH = 20
>>MAX_CHOICE = 9
>>
>>Player 1 will lose.
>
>Player 1 says 9 and win. In this game player one will always win as long as number is greate than 11.
In this example the MAX_CHOICE is the highest number the player can choose so 9 instead of 11 is the max.
1 says 9
2 says 10
Now whatever player 1 says
2 says 20 and wins.
1 says 19
2 says 20 and wins.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only