Excel 2016 - Formula not working, error message

Question

Hi everyone,

When entering a formula, this error keeps coming up. I have checked that I am entering the code correctly and when I send this document to colleagues and they enter the same formula it works without this message popping up. What am I doing wrong?? HELP!

Answer 1

Please enter following formulas and let us know if it gives error -

= 1 + 1

= A1+B1

=SUM(1,2,3)

=SUM(1;2;3)

It it gives error in all cases, I will suggest that you repair your Excel.

Repair the office installation - https://support.office.com/en-NZ/Article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

Answer 2

Hi KirstyHaynes,

You have type a formula in Cell A1, and given the formula with reference for Cell A1.

the error would be appear on screen 

You want to result in Cell A1, and your data is in A2. So why you get the reference in formal for cell A3, or whenever you missed the typing of = sign.

Please type the =LEFT(B3,B) 

check the result.

Hope this will be helpful for you.

Answer 3

Hi,

What formula are you trying to type?

Answer 4

Hi, the same message comes up for any formula I try to use, but this paticular time I was trying to use: =Left (A3,3)

Answer 5

Hi,

Does this work?

=LEFT(A3;3)

Semi colon instead of comma.