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)...
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?