Forum Discussion
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,
4 Replies
You have probably made a mistake somewhere. If you added a few lines but the previous formulation worked, check again the newly added part. I guess it might be something about the separators or parenthesis.
Also, why do you need so many arguments and long formulation? At least you are nesting IF functions which is not that bad for workbook optimization but isn't there another way? I was just curious.
- I tried deleting the most recent ones i had made before it stopped working and I started replacing it with a new formula that was needed. It still after I reached a certain point did the same thing again, and I believe it was the same point. Also when I was working it just cut off as soon as it realises I was typing a cell, eg was fine when I typed J but when I added a 1 it did the same thing. Is there a limit to how many formulas you can put in a cell, or how many times you can reference a cell?
Maximum length of formula characters is 8,192 and maximum nested levels of functions is 64!
Maybe trying to use INDIRECT function and continue writting in another auxiliary cell?
no im trying to make 2048 in excel without macros or vba's for a STEM assigment
