如果公式引用了 Excel 中未定义的名称，则会看到 #NAME？ 错误。 请参阅以下引用 Profit 的 SUM 函数示例，该 函数是工作簿中未定义的名称。. 解决方案：在 名称管理器中定义一个名称，然后按照以下步骤将该名称添加到公式中：. 如果电子表格中已有数据，并且想要为特定单元格或单元格区域分配 ...

The OR function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE.. One common use for the OR function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to ...

Learn how to use Feedback Hub to report problems or send suggestions to Microsoft.

Learn how to use eye control in Windows to type with an on-screen keyboard, communicate with people, and control the mouse with your eyes.

运算符用于指定要对公式中的元素执行的计算类型。 Excel 遵循一般数学规则进行计算，即括号、指数、乘法和除法以及加减法或首字母缩略词 PEMDAS (请原谅我亲爱的阿姨 Sally) 。 使用括号可以更改该计算顺序。 计算运算符分为四种不同类型：算术、比较、文本连接和引用。

A Microsoft account is a personal account required for access to Microsoft’s products and services.

With Power Query, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.

Admins set default meeting settings. They try to optimize for most use cases, but if you want to adjust your options for a specific Teams meeting, go to Meeting options.

Learn what to do if you find charges you don't recognize from Microsoft.

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). Watch more in this video.