If a formula from Bing Chat is not working in Excel, check that it begins with an equals sign, refers to the right cells, uses the argument separator Excel expects, and relies only on functions your Excel version supports. Then use the error message—or the unexpected result—to narrow down the cause; a chat answer can only be as accurate as the workbook details in the prompt.
Why a Bing Chat formula may fail in Excel
Bing Chat was the earlier name for Microsoft’s conversational assistant, now generally branded Microsoft Copilot. A formula suggested in a chat is not automatically tailored to your open workbook. Unless you provide the relevant layout and rules, the assistant has to infer which columns contain inputs, whether the first row is a header, and what result you want. A formula can be syntactically valid but still point to the wrong cells or apply the wrong business rule.
There is also a difference between asking a general chat assistant for a formula and using a Copilot feature inside Excel. The standalone chat may provide text to copy; Excel evaluates that text under the workbook’s own version, regional settings, calculation mode, and data types. Excel’s in-app Copilot features, where available, depend on the Microsoft 365 plan, app version, and organizational settings. Neither a chat response nor a suggested formula is a guarantee that the result is correct.
Before troubleshooting, identify what “not working” means. Excel may reject the formula, show an error such as #NAME?, display the formula as text, return a plausible but incorrect value, or leave an old result on screen. Those symptoms have different causes, so avoid changing several parts of the formula at once.
Start with the formula bar and basic syntax
Click the affected cell and inspect the formula bar. Confirm that the formula starts with =, has balanced parentheses, and contains ordinary straight quotation marks around text values when required. Chat responses sometimes include explanatory prose, Markdown backticks, or a leading apostrophe; those belong outside the formula and can prevent Excel from evaluating it. Copy only the formula itself, not a code fence or trailing explanation.
For a simple check, suppose the values to add are in B2:B4: B2 is 12, B3 is 8, and B4 is 5. The intended total is 25. With that cell layout, use =SUM(B2:B4). If Excel rejects even a simple formula, verify that you entered it in a worksheet cell rather than a text box, and check the separator and cell-format issues described below.
- Look for an extra character before the equals sign, including a space or apostrophe.
- Check that every opening parenthesis has a closing parenthesis.
- Make sure text arguments use straight double quotation marks, not typographic “curly” quotes.
- Remove any Markdown markers such as backticks around the formula.
On Windows, the Formula Bar is above the worksheet grid; selecting a cell there lets you edit the expression directly. Press Enter to commit an edit or Esc to cancel it. On Mac, the formula bar and editing behavior are similar, though keyboard shortcuts can differ by keyboard layout and Excel settings.
Check the cell references against your real layout
A frequent problem is that the formula assumes different columns or rows from the ones in your file. If a chat response uses D2 for a price but prices are actually in column E, the formula may calculate without an error and still be wrong. Compare every reference with the worksheet, including the row where data starts and any header or subtotal rows that should be excluded.
Ask whether the formula should change references when copied. A relative reference such as B2 moves as you fill the formula down. An absolute reference such as $B$2 stays fixed. For example, a tax rate stored in one fixed cell usually needs a locked reference when a calculation is copied, while each row’s quantity should normally move to the next row. Select a reference while editing and press F4 on Windows to cycle through reference styles; on many Mac keyboards, use Command+T or Fn+F4 depending on the keyboard and Excel settings.
Tables introduce another possible mismatch. If the prompt describes a table but the formula uses ordinary cell addresses, the answer may not expand as expected when new rows are added. Conversely, a structured reference such as a table column name works only if the workbook has an Excel table with matching names. Verify the table name and column headings rather than assuming a label in the worksheet is automatically a table field.
Look for separator and regional-setting differences
Excel’s formula argument separator can depend on regional settings. Many installations use a comma between function arguments; some use a semicolon. A formula that is otherwise correct may be rejected if Bing Chat returned commas while the local Excel installation expects semicolons, or the reverse. This is different from commas inside a number format or text string, so change only the separators that divide function arguments.
For instance, suppose C2 contains 82 and the rule is to show Pass for a score of at least 70 and Review otherwise. With the score in C2, a comma-separator installation can use =IF(C2>=70,"Pass","Review"), which returns Pass. If Excel reports a problem with the formula, check whether your installation expects semicolons between the three IF arguments. The comparison and the text results do not change; only the argument separators do.
Do not assume that every formula should be rewritten with semicolons. Excel will usually display formulas using the separators appropriate to that installation. If you are unsure, try a built-in function through the Insert Function dialog, or inspect a working formula in the same workbook. Windows regional settings can influence list separators; managed computers may have settings controlled by an administrator.
Confirm the function exists in your Excel version
A formula can be correct for a newer Excel release and still fail in an older one. Excel 2021 and Microsoft 365 include functions such as XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, SEQUENCE, and LET. LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. If an unavailable function appears, Excel commonly returns #NAME? rather than calculating the intended result.
Check the Excel version under File > Account on Windows; update options and account details may differ on a work-managed device. On Mac, check Excel > About Microsoft Excel. If you need to share a workbook with someone using an older release, ask for a compatible alternative and specify that constraint in the prompt. Avoid replacing a newer function with a complicated workaround until you know what versions the workbook’s users actually have.
Function names can also differ when Excel is set to a language other than English. If the formula came from an English-language chat but your Excel interface uses another language, consult that Excel installation’s function autocomplete or help. Do not guess a translated function name: an incorrect name will not become valid merely because the surrounding syntax is correct.
Use the error or symptom to find the cause
The displayed result is useful evidence. #NAME? often points to an unrecognized function or name, a misspelled function, or text that is missing quotation marks. #REF! indicates an invalid reference, often because a referenced cell or range was deleted. #VALUE! can mean the formula received a value of an unexpected type, such as text where a calculation needs a number. These clues are not absolute diagnoses, but they help focus the next check.
If the cell displays the formula itself instead of the answer, the cell may be formatted as Text, or Show Formulas may be turned on. On Windows, check Home > Number Format and select General, then re-enter the formula by pressing F2 and Enter. Check Formulas > Show Formulas as well. On Mac, the equivalent controls are on the ribbon; keyboard shortcuts can vary, so the ribbon command is the safer check.
If the value looks stale, check Formulas > Calculation Options > Automatic on Windows. A workbook set to manual calculation may not recalculate every formula immediately; pressing F9 recalculates open workbooks on Windows. On Mac, use the Formulas tab’s calculation controls or the available recalculation shortcut for your keyboard. Be careful before changing calculation settings in a large or shared workbook, since the setting can affect more than one formula.
For a formula that returns a believable but incorrect answer, test its pieces in spare cells or use Formulas > Evaluate Formula on Windows to see how Excel processes it step by step. Check for numbers stored as text, dates interpreted differently than expected, hidden spaces, blank cells, and ranges that accidentally include a total row. A formula’s result can be mathematically consistent with its inputs and still fail to represent the intended rule.
Give the chat enough detail to produce a better formula
A more precise prompt reduces guesswork. Describe the columns, first data row, desired output, handling of blanks, and Excel version. Include a tiny fictional example with expected output when the logic is not obvious. Do not paste private customer, employee, health, or financial information simply to demonstrate a formula; replace real values with representative examples and follow your organization’s data-sharing rules.
A useful prompt might say: “In Excel for Microsoft 365 on Windows, dates are in A2:A100 and amounts are in B2:B100. Give me a formula for the total amount where the date is in March 2026. Ignore blank rows, use commas as argument separators, and explain the cell references.” If the formula still fails, provide the exact error and a small sanitized sample of the layout. Ask the assistant to explain what each range refers to, rather than requesting another formula without context.
When checking a suggested formula, treat the explanation and the expression as separate things. A confident-sounding description does not prove that the formula matches your data. Verify the result against a few rows you can calculate manually, especially if the formula affects reporting or operational decisions. For complex rules, build and validate the logic in smaller steps before filling it across a full data set.
Frequently Asked Questions
Why does Excel show the formula instead of the answer?
Check whether the cell is formatted as Text, whether the formula begins with an apostrophe, and whether Formulas > Show Formulas is enabled. Set the cell to General if needed, then re-enter the formula.
Why does Excel say there is a problem with this formula?
Check parentheses, quotation marks, argument separators, and any extra text copied from the chat. Your regional settings may require semicolons instead of commas between function arguments.
What does #NAME? mean in a formula from Bing Chat?
Excel may not recognize a function or name. Check spelling, missing quotation marks around text, and whether your Excel version supports the function used.
Why does the formula work in one workbook but not another?
The workbooks may use different layouts, regional separators, calculation settings, table names, or Excel versions. Compare those conditions and check whether the formula references match the second workbook.
Can Bing Chat see my Excel workbook automatically?
A formula requested in a general chat should not be assumed to have access to the workbook open on your computer. Provide only the layout or sanitized examples needed to describe the task, and use any file-sharing feature only when it is available and permitted for your data.
Related
- Excel Merge Multiple Cells Into One Cell: A Clear Guide
- Excel Merge Two Cells Into One Cell Without Losing Text
- Excel: Merge Data From Multiple Cells Into One Cell
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Verizon Cell Phone Not Working? Fixes to TryIf your Verizon cell phone is not working, first check whether Verizon reports a local network problem, then…
- VLOOKUP Excel Not Working? Fix the Most Common ErrorsIf VLOOKUP in Excel is not working, first set its fourth argument to FALSE for an exact match,…
- Excel Copy and Paste Formula Not Working? Quick FixesIf an Excel formula will not copy and paste correctly, first check whether the copied cell contains a…
- COUNTA Formula Not Working? Fix Common Excel IssuesCOUNTA often seems not to work because it counts cells containing formulas that return an empty string, spaces,…
- COUNTIFS Not Working With Dates? Fix the CriteriaYes—COUNTIFS often misses dates because its criteria are written as text, the cells contain text rather than real…
- Excel XLOOKUP Value Not Available Error: How to FixIn Excel, XLOOKUP’s “value not available” message usually means it could not find the lookup value; the formula…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.