Microsoft Excel

By rudy4pl ·
I wanted to ask a really basic question about excel formulas. Currently im Creating a dice game with 3 dices. I want to see how many doubles and triples and there going to be in 100 trials.
for doubles for 2 dices i got: =IF(AND(A2<>B2);0;1)
Can i get some help finding for 3 dices doubles & triples???

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -

Nested IF

by Bizzo In reply to Microsoft Excel


This will work. You need to check for the triple first, using the AND function, and then for doubles using the OR function.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums