please help again
I am making a function and when I try to add the next argument the entire code goes white and the colouring on the writing to show the cell is referenced by colour coding
=IF(AND($L$5=3,$M$5=2,H5<2),4,IF(AND($L$5=3,$M$5=1,H5<2),2,IF(AND(G10=”left”,H5>0,G5=0,F5=0),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,F5<>H5,I5>0,I5<>H5),H5,IF(AND(H5>0,G5=0,F5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,H5<>F5,I5>0,I5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,F5=G5,I5>0,I5<>H5),I5,IF(AND(G10=”left”,H5>0,G5=0,F5>0,I5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,G5<>F5,H5=I5),H5+I5,IF(AND(G10=”right”,H5>0,I5=H5,G5>0,G5<>F5),G5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=0,F5=H5),H5+F5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=H5),G5+H5,IF(AND(G10=”right”,H5=0,I5>0,G5>0,G5=F5,G5<>I5),G5+F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,F5>0,F5<>G5),F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,G5=F5),0,IF(AND(G10=”right”,H5=0,I5>0,G5>0,F5>0,F5<>G5,I5=G5),F5,IF(AND(G10=”up”,H5>0,H6=H5),H5+H6,IF(AND(G10=”up”,H5>0,H6=0,H7=H5),H5+H7,IF(AND(G10=”up”,H5>0,H6=0,H7=0,H8=H5),H5+H8,IF(AND(G10=”up”,H5=0,H6>0,H6<>H7,H7=0,H6=H8),H6+H8,IF(AND(G10=”up”,H5=0,H6>0,H7<>H6,H7<>0),H6,IF(AND(G10=”up”,H5=0,H6>0,H6=H7),H6+H7,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7=H8),H7+H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”up”,H5=0,H6=0,H7=0,H8>0),H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”down”,H5>0,H6=0),0,IF(AND(G10=”down”,H5>0,H6>0,H6=H5),0,IF(AND(G10=”down”,H5>0,H6>0,H5<>H6,H7=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H5<>H6,H7<>H8,H8=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8=H7),0,IF(AND(H5>0,H6>0,H7>0,H8>0,H8<>H7,H7=H6),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8<>H7,H7<>H6,H5=H6),0,IF(AND(G10=”right”,I5=0,H5>0,G5>0,F5<>G5,F5>0),G5,IF(AND(G10=”left”,H5>0,I5>0,G5>0,
I am making a function and when I try to add the next argument the entire code goes white and the colouring on the writing to show the cell is referenced by colour coding=IF(AND($L$5=3,$M$5=2,H5<2),4,IF(AND($L$5=3,$M$5=1,H5<2),2,IF(AND(G10=”left”,H5>0,G5=0,F5=0),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,F5<>H5,I5>0,I5<>H5),H5,IF(AND(H5>0,G5=0,F5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5=0,F5>0,H5<>F5,I5>0,I5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,F5=G5,I5>0,I5<>H5),I5,IF(AND(G10=”left”,H5>0,G5=0,F5>0,I5>0,F5=H5),0,IF(AND(G10=”left”,H5>0,G5>0,F5>0,G5<>F5,H5=I5),H5+I5,IF(AND(G10=”right”,H5>0,I5=H5,G5>0,G5<>F5),G5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=0,F5=H5),H5+F5,IF(AND(G10=”right”,H5>0,I5>0,I5<>H5,G5=H5),G5+H5,IF(AND(G10=”right”,H5=0,I5>0,G5>0,G5=F5,G5<>I5),G5+F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,F5>0,F5<>G5),F5,IF(AND(G10=”right”,H5=0,I5=0,G5>0,G5=F5),0,IF(AND(G10=”right”,H5=0,I5>0,G5>0,F5>0,F5<>G5,I5=G5),F5,IF(AND(G10=”up”,H5>0,H6=H5),H5+H6,IF(AND(G10=”up”,H5>0,H6=0,H7=H5),H5+H7,IF(AND(G10=”up”,H5>0,H6=0,H7=0,H8=H5),H5+H8,IF(AND(G10=”up”,H5=0,H6>0,H6<>H7,H7=0,H6=H8),H6+H8,IF(AND(G10=”up”,H5=0,H6>0,H7<>H6,H7<>0),H6,IF(AND(G10=”up”,H5=0,H6>0,H6=H7),H6+H7,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7=H8),H7+H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”up”,H5=0,H6=0,H7=0,H8>0),H8,IF(AND(G10=”up”,H5=0,H6=0,H7>0,H7<>H8),H7,IF(AND(G10=”down”,H5>0,H6=0),0,IF(AND(G10=”down”,H5>0,H6>0,H6=H5),0,IF(AND(G10=”down”,H5>0,H6>0,H5<>H6,H7=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H5<>H6,H7<>H8,H8=0),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8=H7),0,IF(AND(H5>0,H6>0,H7>0,H8>0,H8<>H7,H7=H6),0,IF(AND(G10=”down”,H5>0,H6>0,H7>0,H8>0,H8<>H7,H7<>H6,H5=H6),0,IF(AND(G10=”right”,I5=0,H5>0,G5>0,F5<>G5,F5>0),G5,IF(AND(G10=”left”,H5>0,I5>0,G5>0, Read More