Excel Formula to Create Dragon 7

Started by sinister1 2 replies 1,581 views Jump to latest

sinister1
sinister1
  • 9 posts
  • Threads: 4
Joined: Jun 10, 2020
July 2nd, 2020 at 4:03:48 PM #1
Guys, does anyone know what's the Excel formula to create random Dragon 7 decisions (Banker with three card total of 7) in 1000 random baccarat hands?

As per the odds, Dragon 7 appears about 23 times per 1,000 hands.

I am currently using =IF(INT(RAND()*40)=1,"D",IF((INT(RAND()*9048)+1)<4462,"P","B")) to create random appearances of Dragon 7 in 1,000 handsas per the odds.

But, I am not sure if I am doing it right. Can anyone correct me if i am wrong.

Thanks
Ace2
Ace2
  • 2,916 posts
  • Threads: 33
Joined: Oct 2, 2017
July 2nd, 2020 at 4:29:14 PM #2
23 in 1000 is about 1 in 43

=if(Randbetween(1,43)=1,1,0)
It’s all about making that GTA
sinister1
sinister1
  • 9 posts
  • Threads: 4
Joined: Jun 10, 2020
July 2nd, 2020 at 5:41:21 PM #3
Thanks Ace2. So, I was doing it right. I used 40 because 904 pure PB hands / 22.5 odds of Dragon =40.17

Join the discussion

Log in or create a free account to reply to this thread.

  • Jump to: