Dice Roll

[Monitor]

I have tried many different functions to get a text response when I roll - 1,1,1,1,1 or 2,2,2,2,2 using five dice. The table has 100 rows and the numbers are random. I've tried if, Vlookup, Hlookup and or.

 

[bertie]

Everyone else is piling in so, me too.
Why not use the Mod() function with a divisor of 5?

Excel 2007
	A	B	C	D	E	F
1	1	1	1	1	1	success
2	2	2	2	2	1	fail
Sheet1

Cell Formulas
Range	Formula
F1	=IF(MOD(SUM(A1:E1),5)=0,"success","fail")
F2	=IF(MOD(SUM(A2:E2),5)=0,"success","fail")

 

[pgc01]

=IF(DELTA(A1,B1),IF(DELTA(C1,D1),IF(DELTA(E1,D1),"Success","Failure"),"Failure"),"Failure")

Sorry, I'm being a nag today, but this seems not to work.

If A1=B1 and C1=D1=E1 your formula returns Success, even if for ex. A1<>C1, OR B1<>E1, etc.

 

[pgc01]

Everyone else is piling in so, me too.
Why not use the Mod() function with a divisor of 5?

Excel 2007

	A	B	C	D	E	F
1	1	1	1	1	1	success
2	2	2	2	2	1	fail

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F1 =IF(MOD(SUM(A1:E1),5)=0,"success","fail") F2 =IF(MOD(SUM(A2:E2),5)=0,"success","fail") <tbody> </tbody>

<tbody>
</tbody>

Hi Bertie

The fact that the sum of 5 numbers is a multiple of 5 does not make them equal. For ex., test with

1,2,3,4,5

 

[bertie]

Hi Bertie

The fact that the sum of 5 numbers is a multiple of 5 does not make them equal. For ex., test with

1,2,3,4,5

Yep, pretty much realized that as I was pouring a coffee. Och well, back to the drawing board

 

[d'Holbach]

Sorry, I'm being a nag today, but this seems not to work.

If A1=B1 and C1=D1=E1 your formula returns Success, even if for ex. A1<>C1, OR B1<>E1, etc.

Well spotted:

=IF(DELTA(A1,B1),IF(DELTA(C1,D1),IF(DELTA(E1,D1),IF(DELTA(B1,C1),"Success","Failure"),"Failure"),"Failure"),"Failure")

to the op, please don't use this

 

[RoryA]

Just as an alternative:
=REPT("Hooray",MIN(A1:E1)=MAX(A1:E1))

 

[pgc01]

Just as an alternative:
=REPT("Hooray",MIN(A1:E1)=MAX(A1:E1))

Wow! That's a formula!!

 

[shg]

Very nice, Mr. A.

 

[Ingolf]

Just as an alternative:

=IF(SUM(A1:E1)=A1*5,"URA","UUUF")

 

[pgc01]

Just as an alternative:

=IF(SUM(A1:E1)=A1*5,"URA","UUUF")

Sorry, doesn't work. Try with:

2,1,3,1,3