SOLVED

Excel not taking formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1605549%22%20slang%3D%22en-US%22%3EExcel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605549%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20bought%20the%20microsoft%20package%20%26amp%3B%20my%20excel%20is%20not%20taking%20formulas.%20It%20is%20not%20taking%20anything%20starting%20with%20%22%3D%22.%20The%20error%20message%20is%20%22There%20is%20a%20problem%20with%20this%20formula.%20Not%20trying%20to%20type%20a%20formula%3F%20Type%20an%20apostrophe%22.%20I%20have%20gone%20%26amp%3B%20cheked%20in%20the%20files%20option%20if%20the%20calculations%20are%20automatic%20or%20not%20%26amp%3B%20it%20seems%20to%20be%20fine%20there.%20Am%20not%20understanding%20the%20issue.%20Can%20anyone%20please%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605740%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767750%22%20target%3D%22_blank%22%3E%40Aarks%3C%2FA%3E%26nbsp%3BThe%20error%20message%20you%20describe%20occur%20when%20your%20formulae%20have%20syntax%20errors.%20E.g.%20semi-colons%20in%20stead%20of%20commas%2C%20separating%20the%20elements%20of%20a%20formula.%3C%2FP%3E%3CP%3EWhich%20version%20%2F%20language%20are%20you%20on%3F%20Can%20you%20upload%20an%20example%20of%20a%20formula%20you%20try%20to%20enter%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605781%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767750%22%20target%3D%22_blank%22%3E%40Aarks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20with%20something%20like%20%3D1%2B2%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623544%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BA%20simple%20formula%20like%20%22%3DIF(C3%26gt%3B4000%2CTrue%2CFalse)%22.%20I%20really%20do%20not%20think%20it%20is%20because%20of%20the%20symbols%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623546%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623546%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYeah%20it%20is%20taking%20%3D1%2B2.%26nbsp%3BIt%20is%20not%20taking%20IF%2C%20AND%2C%20OR%20formulas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623642%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BPretty%20much%20like%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aarks_0-1598900110589.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215656iB216BF3DC842C760%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Aarks_0-1598900110589.png%22%20alt%3D%22Aarks_0-1598900110589.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623746%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767750%22%20target%3D%22_blank%22%3E%40Aarks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDid%20you%20try%20to%20use%20semicolons%20instead%20of%20commas%3F%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(%20B3%26gt%3B1000%3B%20TRUE%3B%20FALSE)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1625914%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625914%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BGracias%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1626099%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20not%20taking%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767750%22%20target%3D%22_blank%22%3E%40Aarks%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

8 Replies

@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 

Even with something like =1+2 ?

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

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

@Riny_van_Eekelen Pretty much like this

 

Aarks_0-1598900110589.png

 

Best Response confirmed by Aarks (Occasional Contributor)
Solution

@Aarks 

Did you try to use semicolons instead of commas?

=IF( B3>1000; TRUE; FALSE)

 

@Sergei Baklan Gracias

@Aarks , you are welcome