# Software

## Question

Locked

### Microsoft Excel

By ·
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 +

Collapse -

### Nested IF

by In reply to Microsoft Excel

=IF(AND(A1=B1,B1=C1,C1=A1),"triple",IF(OR(A1=B1,B1=C1,C1=A1),"double","singles"))

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

• 0

#### Searching for Program/Software

nicolewhite128 ·

• 5

#### How to choose the best ETL tool?

davidharperint ·

• 1

talibowypl ·

• 2

#### what is matrimonial script any one give ideas ??

matrimonialscript07 ·

• 2