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.