Excel 2016 - Formula not working, error message

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! 

 

Question Info


Last updated September 4, 2018 Views 721 Applies to:
Answer

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.

 

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer

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

Best regards
Vijay Verma

Timezone: UTC+05:30, PST+12:30
Availability Hours (UTC) : 05:00 AM - 06:00 PM

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.