Forum Discussion

Copper Contributor

Aug 22, 2020

Solved

Excel not taking formula

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?

SergeiBaklan
Aug 31, 2020
Aarks

Did you try to use semicolons instead of commas?

=IF( B3>1000; TRUE; FALSE)

8 Replies

SergeiBaklan
Diamond Contributor
Aug 22, 2020
Aarks

Even with something like =1+2 ?
- Aarks
  Copper Contributor
  Aug 31, 2020
  SergeiBaklan Yeah it is taking =1+2. It is not taking IF, AND, OR formulas
Riny_van_Eekelen
Platinum Contributor
Aug 22, 2020
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?
- Aarks
  Copper Contributor
  Aug 31, 2020
  Riny_van_Eekelen Pretty much like this
  - SergeiBaklan
    Diamond Contributor
    Aug 31, 2020
    Aarks
    
    Did you try to use semicolons instead of commas?
    
    =IF( B3>1000; TRUE; FALSE)
- Aarks
  Copper Contributor
  Aug 31, 2020
  Riny_van_Eekelen A simple formula like "=IF(C3>4000,True,False)". I really do not think it is because of the symbols here