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 fo...

SergeiBaklan
Aug 31, 2020
Aarks

Did you try to use semicolons instead of commas?

=IF( B3>1000; TRUE; FALSE)

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
    Sep 01, 2020
    SergeiBaklan Gracias 🙂
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