**Question description:**

*This user has given permission to use the problem statement for this blog.*

## Trying to figure out what is wrong with my formula in Oct-ZD tab in column AY and BG.

Solved by O. Q. in 8 mins

**This is the chat thread from the real Excelchat help session. It contains no private user information.**

**User**10/10/2018 - 08:17

Hello

**Excelchat Expert**10/10/2018 - 08:18

Welcome to ExcelChat!

**Excelchat Expert**10/10/2018 - 08:18

I see that your question is about formula update. I will help you with the problem and explain the solution afterwards.

**Excelchat Expert**10/10/2018 - 08:18

Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.

**Excelchat Expert**10/10/2018 - 08:18

Let me ask you a couple of quick questions to make sure I fully understand your problem.

**Excelchat Expert**10/10/2018 - 08:18

Could you please share a file where you have the problem?

**User**10/10/2018 - 08:19

ok [Uploaded an Excel file]

**User**10/10/2018 - 08:19

ok so if you go to the Oct-ZE tab

**User**10/10/2018 - 08:19

you'll see column AY and BG are giving me a problem with #VALUE!

**Excelchat Expert**10/10/2018 - 08:20

One moment, will check that

**User**10/10/2018 - 08:20

can you help me with that for tabs Oct-Z tabs?

**User**10/10/2018 - 08:20

ok thank you

**Excelchat Expert**10/10/2018 - 08:22

The problem is because in AD10 you have "-"

**Excelchat Expert**10/10/2018 - 08:23

Once you delete it, the problems are gone

**User**10/10/2018 - 08:23

oh ok, let me see

**User**10/10/2018 - 08:23

I didn't even think of tha

**User**10/10/2018 - 08:23

that

**Excelchat Expert**10/10/2018 - 08:23

The thing that this cell is used in the calculation, and when we try to do the math operations with the symbol, which is text, it returns an error

**Excelchat Expert**10/10/2018 - 08:24

I just checked all the related elements, and ended with that cell

**Excelchat Expert**10/10/2018 - 08:24

It was the reason of multiple errors

**User**10/10/2018 - 08:25

ok, look at tab Oct-ZD

**User**10/10/2018 - 08:25

cell BG9

**Excelchat Expert**10/10/2018 - 08:25

The same reason - please remove all the "-" from your cells

**User**10/10/2018 - 08:25

i deleted "-" and it's still giving error

**User**10/10/2018 - 08:26

oh

**User**10/10/2018 - 08:26

nevermind

**Excelchat Expert**10/10/2018 - 08:26

When you use 0 and it is shown as "-" it is okay

**User**10/10/2018 - 08:26

I got it

**Excelchat Expert**10/10/2018 - 08:26

But when you just type the "-" - it is text

**User**10/10/2018 - 08:26

5 - star

**User**10/10/2018 - 08:26

yup, I got it

**Excelchat Expert**10/10/2018 - 08:26

You are welcome, it was a pleasure to assist you! If it happens that you have any Excel or Google Sheets problems in future, please don't hesitate to reach us again.

**User**10/10/2018 - 08:26

thanks

**Excelchat Expert**10/10/2018 - 08:26

You may now end the session, I would highly appreciate if you rate our session at the end and leave some feedback. Have a nice day!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*