The formula in Cell GY2 works when the value in Cell Gu2 is in 3 different cells, but I'm trying to save space, It should be returning the value in Cell GV2. I get a error message. Where am I going wrong?
UNHIT COMBOS AFTER 1000 DRAWS.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
GU | GV | GW | GX | GY | GZ | HA | |||
2 | 000 | EEELLLOOO0 | =MCONCAT(IF(MOD($GU2,{1,2,3},2)=0,"E","O"))&MCONCAT(IF(GU2,{1,2,3},<5,"L","H"))&MCONCAT(IF(MOD(GU2,{1,2,3},8)<3,"O","I"))&(MOD(SUM(GU2,{1,2,3},10))*1 | ||||||
3 | 001 | ||||||||
4 | 002 | ||||||||
5 | 003 | ||||||||
6 | 004 | ||||||||
7 | 005 | ||||||||
8 | 006 | ||||||||
9 | 007 | ||||||||
10 | 008 | ||||||||
11 | 009 | ||||||||
COMBOS |