Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
I think you could try to open after each 3# combo as you worked your way through each 4# combo, so I agree that you could probably ignore them in the answer. Since combination locks would go CW,CCW,CW,CCW or vice-versa I'd think it would be * 2, not * 8. The Permut() formula is for sampling without replacement. However I would expect that numbers could be repeated, so wouldn't the answer be:
=Round(15*2*60^4/86400)
=Round(15*2*60^4/86400)