CODEWITHSUNDEEP
excelsearchsyntaxformula
Julian Herbold
Julian Herbold

Reputation: 537

Excel does not accept any formula

I need to write a formula in Excel to look up specific words and write a string into a field depending on them. However, after first tries I realized that every formula I entered is displayed as false. So I even tried the most simple ones as:

=SUM(H20, B11)

But still, it causes syntax errors. Is something wrong with my Excel? Here is a screenshot of the error that always shows up:

enter image description here

Upvotes: 1

Views: 58

Answers (1)

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 11978

Settings in Excel are important, because they affect functions.

Anyways, the easiest way to know what kind of separator you need when using functions in formula, is looking at the little floating help window Excel shows when using a function.

This works in any Excel version. When you type the complete name of a function, Excel shows a little help window explaining how to use the formula:

enter image description here

As you can see in the image, the semicolon is shown as separator. Depending of how Excel has been set up, this could be a different char, but you could see it in this floating help in any case :)

Upvotes: 1

Related Questions