Code:=IF(DELTA(A1,B1),IF(DELTA(C1,D1),IF(DELTA(E1,D1),"Success","Failure"),"Failure"),"Failure")
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>
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.
=IF(DELTA(A1,B1),IF(DELTA(C1,D1),IF(DELTA(E1,D1),IF(DELTA(B1,C1),"Success","Failure"),"Failure"),"Failure"),"Failure")
Just as an alternative:
=REPT("Hooray",MIN(A1:E1)=MAX(A1:E1))
Just as an alternative:
=IF(SUM(A1:E1)=A1*5,"URA","UUUF")