#NAME? error problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2904809%22%20slang%3D%22en-US%22%3E%23NAME%3F%20error%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904809%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Sir%2C%3C%2FP%3E%3CP%3EI%20can't%20divided%20calculation%20in%20excel.%20Always%20showing%26nbsp%3B%20%23NAME%3F.%20Please%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20sheet%20attach%20for%20your%20ready%20refence%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20Regards%3C%2FP%3E%3CP%3ESoumen%20Maity%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2904809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2904847%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201057%22%20target%3D%22_blank%22%3E%40SoumenMaity%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EIf%20you%20divide%20a%20number%20by%200%20or%20an%20empty%20cell%20(e.g.%20%22%3D%20A1%20%2F%20B1%22%2C%20where%20B1%20is%20empty%20or%20zero)%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eyou%20will%20get%20the%20error%20message%20%22%23%20DIV%20%2F%200!%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EYou%20can't%20divide%20with%20an%20empty%20divisor%20or%200%2C%20as%20I%20learned%20at%20school%20(a%20long%20time%20ago%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20error%20message%20confuses%20sometimes%20the%20user.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThat%20doesn't%20have%20to%20be%2C%20you%20can%20use%20this%20formula%20instead%20of%20the%20simple%20division%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CSTRONG%3E%3D%3C%2FSTRONG%3E%20%3CSTRONG%3EIF%20(ISERROR%20(A1%20%2F%20A2)%2C%20%220%22%2C%20A1%20%2F%20A2)%20%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Eor%20%3CSTRONG%3E%3D%20IFERROR%20(A1%20%2F%20A2%2C%20%220%22)%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Ethere%20are%20a%20few%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Evariants.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThis%20is%20how%20you%20get%20the%20desired%20quotient%20(result).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22%22%3EEnjoy%20excel%3C%2FSPAN%3E%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2904956%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2904956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201057%22%20target%3D%22_blank%22%3E%40SoumenMaity%3C%2FA%3E%26nbsp%3BThe%20%23NAME%3F%20error%20suggest%20that%20you%20are%20using%20an%20incorrect%20function%20name%20or%20reference%20to%20a%20named%20range%20that%20does%20not%20exist%20in%20one%20of%20its%20arguments.%20You%20uploaded%20an%20empty%20file%2C%20which%20isn't%20very%20helpful.%20Can%20you%20try%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905124%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201057%22%20target%3D%22_blank%22%3E%40SoumenMaity%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eoops%20wrongly%20thought%20...%20that%20happens%20when%20the%20thoughts%20are%20faster%20than%20the%20eyes%20allow%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMr.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3ERiny_van_Eekelen%20%3C%2FA%3Erecognized%20it%20correctly%2C%20Danke%20%3A))%3C%2FP%3E%3CP%3EThe%20reason%20for%20the%20%23NAME%20error%20in%20Excel%20is%20the%20incorrectly%20entered%20formula%20name.%20If%20you've%20entered%20a%20formula%20that%20doesn't%20exist%2C%20Excel%20displays%20the%20%23NAME%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%23%20DIV%20%2F%200%20error%20message%20I%20mentioned%20comes%20up%20when%20you%20ask%20Excel%20to%20divide%20a%20formula%20by%20zero%20or%20a%20blank%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Dear Sir,

I can't divided calculation in excel. Always showing  #NAME?. Please help me.

 

Excel sheet attach for your ready refence 

 

Thanks & Regards

Soumen Maity

8 Replies

@SoumenMaity 

If you divide a number by 0 or an empty cell (e.g. "= A1 / B1", where B1 is empty or zero),

you will get the error message "# DIV / 0!".

You can't divide with an empty divisor or 0, as I learned at school (a long time ago :).

The error message confuses sometimes the user.

That doesn't have to be, you can use this formula instead of the simple division:

= IF (ISERROR (A1 / A2), "0", A1 / A2)

or = IFERROR (A1 / A2, "0")

there are a few variants.

This is how you get the desired quotient (result).

 

Enjoy excel

 

@SoumenMaity The #NAME? error suggest that you are using an incorrect function name or reference to a named range that does not exist in one of its arguments. You uploaded an empty file, which isn't very helpful. Can you try again?

@SoumenMaity 

oops wrongly thought ... that happens when the thoughts are faster than the eyes allow

 

Mr. Riny_van_Eekelen recognized it correctly, Danke :))

The reason for the #NAME error in Excel is the incorrectly entered formula name. If you've entered a formula that doesn't exist, Excel displays the #NAME error.

 

The # DIV / 0 error message I mentioned comes up when you ask Excel to divide a formula by zero or a blank cell.

Dear Sir, Please find the attachment & see the small video clip then reply again @Riny_van_Eekelen 

Dear Sir, Please find the attachment & see the small video clip then reply again@Nik@NikolinoDE 

@SoumenMaity 

 

Wrong formula

=H5\I5

 

Right formula

=H5/I5

 

The difference is with slash and backslash.

Use slash "/ ", not backslash  "\"

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

My Dear Sir,
Thank You very Much.. It's properly work right now.

Soumen Maity
I am glad that we could help you.

I also wish you a lot of fun with Excel.