The last one can be simplified to:
entered with ctrl+shift+enterCode:=IF(COUNTIF(A1:E1,A1:E1)<>5,"Fail","Success")
Hi
This formula is wrong, it returns an array. Please check.
There are only five cells total, why not eliminate all but the IF function call (or are the concatenations less efficient than using COUNTIF)?
=IF(A1&B1&C1&D1&E1=A1&A1&A1&A1&A1,"Hooray!","")
A | B | C | D | E | F | G | |
1 | 1 | 11 | 1 | 1 | Hooray! | F1: =IF(A1&B1&C1&D1&E1=A1&A1&A1&A1&A1,"Hooray!","") |
Wouldn't the random numbers the OP is generating to represent dice rolls be limited to the numbers 1 through 6?
A
B
C
D
E
F
G
1
1
11
1
1Hooray!
F1: =IF(A1&B1&C1&D1&E1=A1&A1&A1&A1&A1,"Hooray!","")
<TBODY>
</TBODY>