Excel Formula to Create Dragon 7

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

23 in 1000 is about 1 in 43

=if(Randbetween(1,43)=1,1,0)

Thanks Ace2. So, I was doing it right. I used 40 because 904 pure PB hands / 22.5 odds of Dragon =40.17