Pues hay gente un poco especial y estos tipo son especiales aqui hay una formula para ver la oportunidad de criticos y demas soquetadas pero hay que tener WEB BOSSSSS
Now if we make a second row just to define if a value exists and if it is critical we can use a formula like:
And for each of Player A’s die rolls the following are critical (1) or non existent (-1)
B4 = IF(OR($A4=$A$25,40-$A$25<=$A4),1,IF($A4>$A$25,-1,0))
B5 = IF(OR($A5=$A$25,40-$A$25<=$A5),1,IF($A5>$A$25,-1,0))
…
B24 = IF(OR($A23=$A$25,40-$A$25<=$A23),1,IF($A23>$A$25,-1,0))D2 =
And for each of Player B’s die rolls the following are critical (1) or non existent (-1)
D2 = IF(OR(D$1=$B$25,40-$B$25<=D$1),1,IF(D$1>$B$25,-1,0))
E2 = IF(OR(E$1=$B$25,40-$B$25<=E$1),1,IF(E$1>$B$25,-1,0))
…
W2 =IF(OR(W$1=$B$25,40-$B$25<=W$1),1,IF(W$1>$B$25,-1,0))
Which just leaves two special cases
Your failed result will always be non critical, but if target is 20 or more you can never fail so
B3 = IF($A$25>=20,-1,0)
C2 = IF($B$25>=20,-1,0)
You could then enter in the logic statement in cell C3 and drag to fill the rest, it’s a horrible formula but it is just the logic statement given previously.
=IF(OR(C$2=-1,$B3=-1), "", IF(AND(C$1=0,$A3=0), "Tie", IF($B$25=$A$25, IF(C$1>$A3, "A", IF($A3>C$1, "B", "Tie")), IF($A$25>$B$25, IF(AND(C$2=1,$B3=0), "B" ,IF($A3>=C$1, "A", "B")), IF(AND(C$2=0, $B3=1), "A", IF(C$1>=$A3 , "B" , "A"))))))
http://infinity-math.appspot.com/
Y est ees el programa ya armado hahahahah Dios pienso que no soy tanbueno en lo que hago