**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.*