Please help urgent due FRIDAY

I am working on coding a game in excel 2048. I haven't used any macros or VBA's and I have made I combined function for the movement and whether a 2 or 4 can spawn in that cell with an IF AND functio...

excel

Formulas and Functions

Steve_SumProductCom
Jul 30, 2024
cookie02 You can use the Value Preview Tooltips to help find the problem. Start with the last IF in your formula. Put your cursor somewhere within that, and then click on the "value_if_false" part of the tooltip. It will highlight that part of the formula. Work your way back through the formula by selecting each argument in the tooltip, then look at what's highlighted. Then move back to the previous IF statement in your formula and repeat.

Eventually, you will find the one I have highlighted below with the extra argument.

Steve_SumProductCom

MVP

Jul 30, 2024

cookie02 You can use the Value Preview Tooltips to help find the problem. Start with the last IF in your formula. Put your cursor somewhere within that, and then click on the "value_if_false" part of the tooltip. It will highlight that part of the formula. Work your way back through the formula by selecting each argument in the tooltip, then look at what's highlighted. Then move back to the previous IF statement in your formula and repeat.

Eventually, you will find the one I have highlighted below with the extra argument.

cookie02

Copper Contributor

Jul 30, 2024

thank you, absolute life saver, i though i just had too many functions or something.

Steve_SumProductCom
MVP
Jul 30, 2024
That's great. Please mark my reply as Answer.

Forum Discussion

Please help urgent due FRIDAY