TL;DR:
An error message is a clue: read it, find where it points, then test one cause at a time.
Showing an assistant the message and the cell or line it points to gets a better answer than describing it.
Make the smallest change that fixes it, and check that the error is really gone.
Error messages have a bad reputation, mostly because people read them as shouting. They are better read as short notes from the software: "I tried to do what you asked, and this is the part I could not do." Once you read them that way, they become one of the most useful pieces of information on your screen.
Here is a spreadsheet error worked step by step, with an assistant helping you look, not guessing for you.
The situation
You have a sheet with quantities in column B and prices in column C. In D2 you wrote =B2*C2, and the cell shows #VALUE!. Other rows work fine. Only row 2 fails.
Walk-through: a spreadsheet #VALUE! error
Read the message:
#VALUE!in a spreadsheet generally means a formula got a value of the wrong type, such as text where it needed a number. It does not say which input, so you have to look.Find what it points at: The formula uses two cells, B2 and C2. One of them must be the culprit. Because other rows work, the problem is in the data of row 2, not the formula.
Look at the inputs: You click B2 and see
12 units. Click C2 and see3. The word "units" turned a number into text.Test the idea: In an empty cell type
=ISNUMBER(B2). It returns FALSE, which confirms B2 is not a number to the spreadsheet.=ISNUMBER(C2)returns TRUE.Make the smallest fix: Change B2 to just
12, and put "units" in the column heading instead. D2 now shows36.Check:
12 × 3 = 36. Each row below still works. The error is gone, and no formula was rewritten.
Notice what the process was. Read, locate, inspect, test, fix, verify. You can do these six moves on nearly any error in any software, and an assistant can help with each of them.
What to show an assistant
The most useful things to give are the exact message and the thing it points at. Say or show: "this cell shows #VALUE!, here is the formula, and the cells it uses." With a screen-aware assistant, it can see the cells directly and you can point to the one that bothers you.
A description like "my sheet is broken" leaves it guessing. With the message and the formula in view, it can usually name the likely cause in one sentence, and then it is your job to confirm it with a test like the ISNUMBER one above.
It is worth noticing why the fix was gentle. The tempting move is to rewrite the formula, wrap it in an error-hiding function, or copy a different formula from somewhere. Each of those can make the red symbol vanish while leaving the bad data in place. The cell would then show a wrong number or a blank, which is worse than an honest error because nobody notices.
Common patterns in error messages
It names a thing that does not exist. A misspelt function, a missing file, or a sheet that was renamed.
It names a type mismatch. Text where a number was expected, or the reverse.
It names a limit. A divide by zero, a number too large, a full disk.
It names a permission or a connection. You are not signed in, or the network is down.
Knowing which of these four families you are in narrows the search at once.
Habits that save time
Read the whole message, including the part you want to skip.
Note where it points: a cell, a line number, a file name.
Change one thing at a time, so you know which change worked.
Undo changes that did nothing.
Search the exact wording of the message if the cause is not clear.
Watch out: Do not follow a fix that deletes data, changes system settings or runs unfamiliar commands without understanding what it does. If an assistant suggests something like that, ask it to explain first, and keep a copy of your file.
What an assistant cannot tell you
Some causes are invisible from the screen: a setting in another file, a service that is down, a permission that was changed last week. In those cases the assistant can suggest where to look, but you have to do the looking and report back.
Privacy and control
When you show an assistant an error, check what else is on screen. Error pages sometimes contain file paths, account names or tokens. DuckyHelper only looks while the pill is open and for that answer, and it can draw on your screen to point at the cell or line that matters.
Try it yourself
Make an error on purpose in a spreadsheet: type "12 units" into a cell and multiply it. Read the message, find the cause, and fix it. Doing it once in a safe sheet makes the real one less stressful.
Frequently asked questions
Should I just search the error message online?
It often works. An assistant that can see your screen can add the context a search cannot: your actual formula and data.
What if the fix does not work?
Undo it, and tell the assistant what you changed and what happened. That is new information that narrows the cause.
Do all errors mean I did something wrong?
Not always. Errors can originate in the software itself, in an online service or on the network, so read the message first to work out which one you are dealing with.
Get started
