Excel not taking formula

[Aarks]

I just bought the microsoft package & my excel is not taking formulas. It is not taking anything starting with "=". The error message is "There is a problem with this formula. Not trying to type a formula? Type an apostrophe". I have gone & cheked in the files option if the calculations are automatic or not & it seems to be fine there. Am not understanding the issue. Can anyone please help?

[#2]

@Aarks The error message you describe occur when your formulae have syntax errors. E.g. semi-colons in stead of commas, separating the elements of a formula.

Which version / language are you on? Can you upload an example of a formula you try to enter?

[#3]

@Aarks 

Even with something like =1+2 ?

[#4]

@Riny_van_Eekelen A simple formula like "=IF(C3>4000,True,False)". I really do not think it is because of the symbols here

[#5]

@Sergei Baklan Yeah it is taking =1+2. It is not taking IF, AND, OR formulas

[#6]

@Riny_van_Eekelen Pretty much like this

[#7 · Accepted solution]

@Aarks 

Did you try to use semicolons instead of commas?

=IF( B3>1000; TRUE; FALSE)

[#8]

@Sergei Baklan Gracias :)

[#9]

@Aarks , you are welcome