Forum Discussion

Aarks's avatar
Aarks
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's avatar
    SergeiBaklan
    Aug 31, 2020

    Aarks 

    Did you try to use semicolons instead of commas?

    =IF( B3>1000; TRUE; FALSE)

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 22, 2020

Aarks 

Even with something like =1+2 ?

Aarks's avatar
Aarks
Copper Contributor
Aug 31, 2020

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

Resources