在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 ...
AND 和 OR 函数最多可支持 255 个单独条件，但并不建议使用多个条件，因为构建、测试和维护复杂的嵌套公式是非常难的。. NOT 函数仅采用一个条件。. 下面是根据它们的逻辑写出的公式：. 公式. 说明. =IF (AND (A2>0,B2<100),TRUE, FALSE) 如果 A2 (25) 大于 0，并且 B2 (75 ...
适用于:
Microsoft 365 专属 Excel, Microsoft 365 Mac 版专属 Excel, Excel 网页版, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Screen mirroring and projecting to your PC or wireless display
Cast to a Windows PC from another Windows PC. On the PC you'd like to project from, select Start > Settings > System > Projecting to this PC . Under Add the “Wireless Display” optional feature to project to this PC, select Optional features . Next to Add an optional feature, select View features, then enter “wireless display.”.
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Select Install (or depending on your version, Install apps> ). From the home page select Install apps (If you set a different start page, go to aka.ms/office-install .) For Microsoft 365 operated by 21 Vianet go to login.partner.microsoftonline.cn/account. For Microsoft 365 Germany go to portal.office.de/account.
适用于:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 家庭版, Office 商业版, Office 365 小型企业版, Microsoft 365 管理员, 由世纪互联运营的 Office 365, 由世纪互联运营的 Office 365 - 管理员版, Microsoft 365 Mac 版, Office 365 Germany – 企业版, Office 365 Germany - 企业管理员版
Activate Windows - Microsoft Support
Activate Windows using a product key. A product key is a 25-character code, that looks like this: PRODUCT KEY: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX. During installation, you'll be prompted to enter a product key. Or, after installation, to enter the product key, select the Start button, and then select Settings > System > Activation > Update product ...
Fix Bluetooth problems in Windows - Microsoft Support
Here’s how: Check in quick settings: Select the Network, Sound, or Battery icons ( ) on the right side of the taskbar, look for the Bluetooth quick setting, then select Bluetooth to turn it on. You’ll see “Not connected” if your Windows 11 device isn’t connected to any Bluetooth accessories. Check in Settings: Select Start > Settings ...
How to use the PC Health Check app - Microsoft Support
How to open PC Health Check. In Windows, use Search on the taskbar to search for “PC Health Check,” then select it from the list of results. If a PC Health Check update is available, you can quickly install it for the latest version. If you don't have PC Health Check installed, you can install it by going to https://aka.ms ...
更改或删除单个页面上的页眉或页脚 - Microsoft 支持
双击页眉或页脚区域以打开 “页眉 & 页脚 ”选项卡。. 选择“ 链接到上一个” 以关闭各部分之间的链接。. 选择 “删除页眉”或“删除页脚 ”。. 添加或更改页眉或页脚中的内容。. (如果要删除或更改页眉和页脚，则需要重复步骤 3-5。. 若要返回到文档正文 ...
适用于:
Microsoft 365 专属 Word, Microsoft 365 Mac 版专属 Word, Word 网页版, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Microsoft 365 Customer Service and Support - Microsoft Support
Chat or receive a call back from a technical support expert: If you have a Microsoft 365 Basic, Microsoft 365 Personal, or Microsoft 365 Family subscription, get questions answered from anywhere via chat or request to receive a call back from one of our technical support experts. See the table below for the type of support you can get depending ...
适用于:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 家庭版
将两个或更多个单元格的文本合并到一个单元格 - Microsoft 支持
使用 CONCAT 函数合并数据. 选择要放置合并后数据的单元格。. 键入“ =CONCAT ( ”。. 首先选择要合并的单元格。. 使用逗号分隔要合并的单元格，使用引号添加空格、逗号或其他文本。. 在公式末尾添加括号，然后按 Enter。. 示例公式可能是“ =CONCAT (A2, " Family") ”。.
适用于:
Microsoft 365 专属 Excel, Microsoft 365 Mac 版专属 Excel, Excel 网页版, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Mobile
获取最新 Windows 更新 - Microsoft 支持
若要检查更新，请选择“ 开始 > 设置 > Windows 更新 ”，然后选择“ 检查更新 ”。. 如果有可用的更新，可以选择安装它们。. 检查更新. 如果在更新设备时遇到问题（包括以前的主要更新出现问题），请参阅 排查更新 Windows 问题 中的常见修补程序。. 如果Windows ...