# Advanced Probability Help

#### giants756

##### New Member
I need help creating a formula determining if the "ATTACKER" lands a Hit on the "DEFENDER". There are many factors that go into this and I can't seem to figure it out... I've uploaded an image of all the dice possibilities.

Example Scenario

 ATTACKER'S DICE DEFENDER'S DICE Yellow (D12) 2 Red (D12) 1 Green (D8) 4 Purple (D8) 2 Blue (D6) 2 Black (D6) 1

Factor 1: There are multiple of each dice and each color dice has different result possibilities (Refer to image for percentages)
Factor 2: Some sides of the dice count as 1 Hit, some 2 Hits, and some 3 Hits. (And the same goes for the dice used for blocking)
Factor 3: I am comparing the number of Hits vs the number of Blocks rolled. Each Block cancels out a Hit.
Factor 4: A tie goes to the Defender because in the case all of the Hit's would be Blocked.

So the situation is (Yellow, Green, Blue used for attacker) VS (Red, Purple, Black used for defender).
I'm needing to know what th
e percentage is that the ATTACKER lands at least 1 more Hit than the DEFENDER does Blocks (Basically I need to know what the chances are that the attack will hit the defender.

The attached image shows the number of sides on the dice that count for each Hit/Block. For example: the yellow dice has 1 side that counts as 3 Hits (8% chance of landing on that side).

If you need any more information let me know! I greatly appreciate any help I can get! I've been trying to figure out how to do this for a while and can't seem to wrap my head around all the possibilities.

#### giants756

##### New Member
I see that I was a little slow in responding^^^
I was just about to see if I can get a decent probability of throwing scores 0 - 8, based on the chart below which shows the required 1,2,3's needed (any balance being 0's)
Note that combinations needing more than one 3 cannot be thrown.

Book1
NOPQRSTUVW
1Score
200
311
42112
53111123
6411111122213
7511111111211312223
86111111111121113112212333
971111111111112111131112211231222133
10811111111111111211111311112211123112222222233
119111111111111111211111131111122111123111222122221233333
Sheet2

@giants756 What is the motive behind you wanting this? How accurate do you need it? Is it worth me missing the football on TV to pursue it?
I appreciate all the help! I think I have what I’m looking for with this Hit to Block Ratio. I think it’s just too much to try and comprehend finding the percent chance of hitting. Definitely seems like there are a lot of possibilities to consider for a percent and I think the Ratio gives me a better perspective.

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Replies
1
Views
444
Replies
1
Views
197
Replies
9
Views
104
Replies
7
Views
885
Replies
6
Views
180

Threads
1,129,483
Messages
5,636,604
Members
416,929
Latest member
Nitil

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back