#### 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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
1
Views
428
Replies
1
Views
155
Replies
9
Views
101
Replies
7
Views
879
Replies
6
Views
177

1,127,894
Messages
5,627,498
Members
416,250
Latest member
darius_rebelo

### 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.

### Which adblocker are you using?

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

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