Forum Discussion
Solved
#NAME? error problem
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
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)
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.