Forum Discussion
Formula in table doesn't calculate
That's weird. When I create such a formula in the Dutch version of Excel Online, it also inserts a semicolon - see 1.
But when I remove the semicolon, the formula works as intended - see 2.
Thx for replying.
I created the formula by clicking on the cells. So Excel generated the notation with the semicolons (;).
When I remove the semicolons and give <enter>, Excel re-inserts the semi-colons and returns to the state as depicted in the original post.
Edit: it appears to be a problem with Excel online, because on Excel desktop app I cannot reproduce the problem. Unfortunately, security measures don't allow me to download the original excel file to my desktop.
That's weird. When I create such a formula in the Dutch version of Excel Online, it also inserts a semicolon - see 1.
But when I remove the semicolon, the formula works as intended - see 2.
- Why a 2 years old bug is still open???
HansVogelaar It happens to with with "downloaded" files. The solution in my case is change che cell type from "text" to "general".
After converting the cell Excel is accepting formulas
- weird bug, and it still happens in 2024.
