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.