Coda has no issues dealing with basic arithmetics. I suspect the issues are that you might be using commas , instead of points . as a decimal separator and square brackets [ ] instead of parentheses ( ).
But we can’t tell you for sure where the mistake is unless you share a dummy doc with us.