Forum Discussion
cookie02
Aug 01, 2024Copper Contributor
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)...
Martin_Angosto
Aug 01, 2024Iron Contributor
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.
cookie02
Aug 01, 2024Copper Contributor
no im trying to make 2048 in excel without macros or vba's for a STEM assigment