One cell showing #SYNTAX_ERROR


Line 5 Cell E5 formula is =A5C5 Showing #SYNTAX_ERROR
It is the same formula that is in line 8 =A8
C8 and works fine.
When I copy the formula from E8 into E5 it works. ???
Change just the 8 to 5 and it fails.
If you want to see the Spreadsheet it is
I’m sure it’s something stupid I am doing.
How can I fix this?
Thanks for your help!!!


sorry for the delay in answerring.
I tried to reproduce your problem at local computer, but it works correctly.
Also I can’t have a look at your spreadsheet, it looks like you are using another spreadsheet in provided link.


Same problem i am facing … My formulas shown #Syntax error and after double click it will be ok…


Could you please, provide a complete demo or a demo link, where the problem can be reconstructed locally.


Please review this screen shot …


Unfortunately the mentioned problem cannot be reconstructed locally.
Could you please, provide a complete demo where the problem can be reconstructed.