Shulou(Shulou.com)06/01 Report--

This article mainly explains the "excel cell appears # NAME? how to solve the error", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "excel cell # NAME? how to solve the error" bar!

This kind of error is generally Excel can not recognize the text in the formula, this kind of error is more common, introduce three common kinds.

1. There are no parentheses in the formula

There are no parentheses in the formula

The correct formula is = sum (b2:c2)

2. The function name in the formula is misspelled.

The function name is misspelled.

The function of summation should be SUM

3. The text in the formula is not in double quotation marks.

Text without double quotation marks

The correct way to write it is: = (B4-C4) & "Yuan"

Thank you for your reading, the above is the content of "excel cell # NAME? how to solve the error". After the study of this article, I believe you have # NAME for excel cells? Error how to solve this problem has a deeper understanding, the specific use of the situation still needs to be verified by practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.