Share via

Using C# I receive a "NAME" error

TROY c 60 Reputation points
2024-04-05T20:42:18.16+00:00

The instruction IF(AND(D36="DC",A11="WY25",D38=”INTSUM”),FWDD,NONE) gives an error (NAME at INTSUM).

Bold only here to point to the location of the error.

INTSUM is a text from a dropdown list. This dropdown list also has the text SCM which also results with the error.

FWDD and NONE are named locations. These aren't the problem.

The dropdown list doesn't appear to be an issue either because "WY25" is also from a dropdown list all be it from a different list.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,898 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,910 questions
Accepted answer
  1. Barry Schwarz 2,901 Reputation points
    2024-04-06T01:15:56.5666667+00:00

    For whatever reason, you first two strings are enclosed in dumb quotes (" ") while the third is enclosed in smart quotes which I cannot reproduce in this message but which appear in Excel as small superscript commas. Replacing them with dumb quotes solved the problem.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.