Qoraalkan, waxaanu ku tusi doonaa cashar aad ku hagaajiso #NAME?qaladka Microsoft Excel . Kahor intaanan ka hadlin casharrada si loo saxo #NAME?qaladka, aan fahanno sababta qaladkan uu uga dhaco Excel .

Maxaan u arkaa #NAME? qaladka Excel?

Waa kuwan sababaha suurtogalka ah ee aad u aragto # MAGACA^(NAME) ? Fariinta qaladka ah ee Excel :

• Marka aad geliso magac qaacido khaldan ama xadhig ama uu jiro wax far ah oo qaacidada ah, waxay soo celinaysaa # MAGACA^(NAME) ? fariinta qaladka ee unugyada.
• Waxay ku tusaysaa in ay wax ka khaldan yihiin hab-raacyada aad isticmaashay oo u baahan in la saxo.
• Haddii aad isticmaashay qaacido tilmaamaya magac aan la qeexin, waxaad heli doontaa fariintan qaladka ah.
• Haddii uu jiro xiidan ka maqan tixraaca kala duwan, waxay soo celin doontaa # MAGACA^(NAME) ? qalad
• Waxaad arki doontaa # MAGAC ^(NAME)fariinta qaladka ah haddii aad isticmaalayso qaar ka mid ah hawlaha u baahan add-in, iyo add-in waa naafo.

Hadda, sida loo xalliyo # MAGACA^(NAME) ? qaladka Excel ? Si ka duwan khaladaadka kale ee Excel , tusaale ahaan, #DIV/0! error , qaladkan laguma hagaajin karo iyada oo la adeegsanayo wax ka qabashada khaladaadka sida IFERROR . Halkan, waxaynu ku taxnayn doonaa xalalka lagu hagaajinayo laguna saxayo # MAGACA^(NAME) ? qalad

Sida loo saaro #NAME? Khaladka Excel

Waa kuwan hababka lagu saxo ama loo hagaajiyo # MAGACA^(NAME) ? qalad ku jira buugaagtaada shaqada ee Excel :

1. Isticmaal^(Use) soo jeedinta caanaha ama saaxirka shaqada^{(Function Wizard)} si aad uga fogaato khaladaadka syntax.
2. Gacanta ku hubso qoraal kasta oo shaqada ku jira oo sax
3. Hubi haddii magaca lagu isticmaalo qaacidada uu ku qeexan yahay Maamulaha Magaca^{(Name Manager)} .
4. Hubi in qiyamka qoraalku ay leeyihiin calaamado xigasho oo ku wareegsan.
5. Daar ku-darka loo baahan yahay shaqada la isticmaalay.

Aan si faahfaahsan uga doodno hababkan hadda!

1] Isticmaal^(Use) talooyinka qaacidada ama Wizard Function^{(Function Wizard)} si aad uga fogaato khaladaadka syntax

Microsoft Excel waxa ay soo bandhigaysaa liis habab iswaafaqaya isla marka aad bilowdo in aad shaqada ku qorto barta shaqada.

Hubi^(Make) inaad isticmaasho qaacido ka mid ah talooyinka halkii aad gacanta ku qori lahayd. Haddi aad gacanta ku qorto qaacido, waxa ay kordhinaysaa jaanisyada qaladaadka lagu qorayo oo markaas tuso # MAGACA^(NAME) ? qalad

Waxa kale oo aad isticmaali kartaa Wizard Function^{( Function Wizard)} si aad uga fogaato khaladaad kasta oo isku mid ah. F

ama taas, si fudud u dooro unugga oo aad tab tab Formulas oo guji ikhtiyaarka Gelida Function . ^{(Insert Function)}Saaxir Function Insert^{(Insert Function)} ah ayaa furmi doona halkaas oo aad ka dooran karto qaacidada aad u baahan tahay si aad u gasho unugga.

2 ] Gacanta^{(] Manually)} ku hubi qoraalka ku jira shaqada oo sax

Haddii ay jiraan qoraallo yaryar, waxaad ku sixi kartaa gacanta. Kaliya fiiri shaqada aad isticmaashay oo baar si aad u aragto haddii uu jiro qalad higaada ee xargaha qaacidada.

Hadday sidaas tahay, si fudud u sax oo waxay meesha ka saaraysaa # Magaca^(Name) ? qalad Haddii ay jiraan sababo kala duwan oo qaladkan, isticmaal hab kale oo ka mid ah qodobkan si aad u hagaajiso.

3] Hubi^(Check) haddii magaca loo adeegsaday qaacidada lagu qeexay Maareeyaha Magaca^{(Name Manager)}

Haddii ay dhacdo inaadan qeexin magac tixraac ku leh qaacidadaada, wuxuu soo celinayaa # Magaca^(Name) ? qalad Markaa, hubi oo qeex magaca adoo isticmaalaya Maareeyaha ^(Manager)Magaca^(Name) ee Excel . Waxaad raaci kartaa tillaabooyinka hoose si aad sidaas u sameyso:

Excel, u tag Formulas tab oo guji batoonka hoos u dhaca Magaca Qeexay . ^{( Defined Name)}Kadibna, dooro ikhtiyaarka Maareeyaha Magaca .^{(Name Manager)}

Daaqadda Maareeyaha^(Manager) Magaca , eeg haddii magaca aad isticmaashay la qeexay iyo in kale. Haddii kale, dhagsii badhanka Cusub^(New) .

Hadda, geli magaca oo guji badhanka OK.

Dib^(Reenter) u geli qaacidada magaca aad hadda qeexday oo ma arki doontid # MAGACA^(NAME) ? khalad hadda.

4] Hubi in qiyamka qoraalku ay leeyihiin calaamado xigasho oo ku wareegsan

Haddii aad isticmaalayso tixraacyo qoraal ah qaacidada, waa inaad ku xidhaa calaamadaha xigashada. Haddii kale, waxaad heli doontaa # MAGACA^(NAME) ? fariinta qaladka ee unugyada.

Xalku waa in si dhow loo eego xadhkaha qaacidada oo hubi haddii calaamadaha xigashada si habboon loogu daray. Haddii kale, si fudud u dhig calaamadaha xigashada agagaarka tixraacyada qoraalka. Tani waxay hagaajin doontaa qaladka.

5] Daar^(Enable) ku-darka loo baahan yahay shaqada la isticmaalay

Qaar ka mid ah hawlaha caadiga ah ee Excel waxay u baahan yihiin wax-ku-dar si ay u shaqeeyaan. Tusaale ahaan, shaqada EUROCONVERT waxay u baahan tahay qalabka lacagta Euro^{(Euro Currency Tools)} in lagu daro si ay u shaqeyso. Sidoo kale, shaqooyinka kala duwan ee xisaabaadka iyo injineernimada waxay u baahan yihiin ku-dar- gelinta Falanqaynta ToolPak^{(Analysis ToolPak)} si loo hawlgeliyo. Marka, si fudud u suurta geli ku-darka loo baahan yahay mana soo celin doono # Magaca^(Name) ? qalad

Waa kuwan tillaabooyinka lagu suurtagelinayo add-in Excel :

1. Tag liiska faylka^(File) oo guji  Options .
2. U gudub tab -ku-darka^(Add-ins) oo dhagsii badhanka Go ee ag yaal ikhtiyaarka Maamul Add-ins-ka ee Excel .^{(Manage Excel Add-ins)}
3. Daaqadda wada - hadalka Add-ins , awood sanduuqyada hubinta ee khuseeya inay shid ku-darka loo baahan yahay.
4. Taabo batoonka OK oo arag haddii # ^(OK)Magaca^(Name) ? qaladku waa go'an yahay.

Waa kaas! Rajaynaynaa in maqaalkani kaa caawiyo hagaajinta # MAGACA^(NAME) ? qaladka Microsoft Excel .

Hadda akhri: ^{(Now read:)} Sida loo hagaajiyo qaladka Runtime 1004 ee Excel^{(How to Fix Runtime Error 1004 in Excel)}

How to remove #NAME? Error in Excel?

In thіs post, we arе going to show you a tutorial to fix #NAME? error in Microsoft Excel. Before talking about the tutorial to correct #NAME? error, let us understand why does this error occurs in Excel.

Why do I see #NAME? error in Excel?

Here are the possible reasons due to which you see a #NAME? error message in Excel:

• When you have entered a wrong formula name or string or there is some typo in the formula, it returns #NAME? error message in the cells.
• It indicates that something is wrong with the syntax you have used and that needs to be corrected.
• If you have used a formula that refers to a name that is not defined, you will get this error message.
• In case there is a colon missing in the range reference, it will return #NAME? error.
• You will see a #NAME? error message if you are using some function that needs an add-in, and the add-in is disabled.

Now, how to resolve #NAME? error in Excel? Unlike some other errors in Excel, e.g., #DIV/0! error, this error can’t be fixed using any error handling function like IFERROR. Here, we are going to list some solutions to fix and correct #NAME? error.

How to remove #NAME? Error in Excel

Here are the methods to correct or fix the #NAME? error in your Excel workbooks:

1. Use formula suggestions or Function Wizard to avoid syntax errors.
2. Manually check for any typo in the function and correct it.
3. Check if the name used in the formula is defined in Name Manager.
4. Ensure that the text values have quotation marks around them.
5. Enable the add-in required by the used function.

Let have a detailed discussion on these methods now!

1] Use formula suggestions or Function Wizard to avoid syntax errors

Microsoft Excel displays a list of matching formulas as soon as you start typing the function in the function bar.

Make sure you use a formula from the suggestions rather than typing it all manually. If you type a formula manually, it increases the chances of typing errors and thus showing a #NAME? error.

You can also use the Function Wizard to avoid any syntactic errors. F

or that, simply select the cell and go to the Formulas tab and click on the Insert Function option. An Insert Function wizard will open up where you can select the formula you need to enter to the cell.

2] Manually check for the typo in the function and correct it

If there are some minor typos, you can correct them manually. Just have a look at the function you have used and inspect it to see if there is a spelling error in the formula string.

If so, simply correct it and it will eliminate #Name? error. In case there is some different cause for this error, use another method from this article to fix it up.

3] Check if the name used in the formula is defined in Name Manager

In case you haven’t defined a name that has a reference in your formula, it returns #Name? error. So, check and define a name using the Name Manager in Excel. You can follow the below steps to do so:

In Excel, go to the Formulas tab and click on the Defined Name drop-down button. And then, select the Name Manager option.

In the Name Manager window, see if the name you have used is defined or not. If not, click on the New button.

Now, enter the name and click the OK button.

Reenter the formula with the name you just defined and you won’t see the #NAME? error now.

4] Ensure that the text values have quotation marks around them

If you are using text references in the formula, you must enclose them in quotation marks. Else, you will get a #NAME? error message in the cells.

The solution is that look closely at the formula string and check if the quotation marks are added properly. If not, simply put the quotation marks around the text references. This will fix the error.

5] Enable the add-in required by the used function

Some custom Excel functions need add-ins to work. For example, the EUROCONVERT function needs Euro Currency Tools add-in to work. Also, various statistical and engineering macro functions require Analysis ToolPak add-in to be enabled. So, simply enable the required add-in and it won’t return #Name? error.

Here are the steps to enable the add-in in Excel:

1. Go to the File menu and click on Options.
2. Navigate to the Add-ins tab and click on the Go button present beside the Manage Excel Add-ins option.
3. In the Add-ins dialog window, enable the relevant checkboxes to turn on the required add-in.
4. Tap on the OK button and see if the #Name? error is fixed.

That’s it! Hope this article helps you fix #NAME? error in Microsoft Excel.

Now read: How to Fix Runtime Error 1004 in Excel

Related posts

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loogu daro fariimaha khaladka ah gudaha Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sida Looga Daro Baararka Cilada ee Excel

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel