Aug 22 2020 07:18 AM
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?
Aug 22 2020 11:08 AM
@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?
Aug 31 2020 11:00 AM
@Riny_van_Eekelen A simple formula like "=IF(C3>4000,True,False)". I really do not think it is because of the symbols here
Aug 31 2020 11:02 AM
@Sergei Baklan Yeah it is taking =1+2. It is not taking IF, AND, OR formulas
Aug 31 2020 12:43 PM
SolutionAug 31 2020 12:43 PM
SolutionDid you try to use semicolons instead of commas?
=IF( B3>1000; TRUE; FALSE)