Language Accessory Pack for Microsoft 365 - Microsoft Support
Learn how to download, install, and configure Language Accessory Packs for Microsoft 365 for additional display, help, and proofing tools.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin
Deprecation of Microsoft Support Diagnostic Tool (MSDT) and MSDT ...
Devices running Windows 11 version 22H2 and older. If you're running Windows 11 version 22H2 and older, Windows 10, Windows 8.1, Windows 7 or any other earlier OS version, your device will not be affected by the MSDT Troubleshooter retirement.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
AVERAGEIF function - Microsoft Support
This article describes the formula syntax and usage of the AVERAGEIF function in Microsoft Excel.. Description. Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App
SI (SI, fonction) - Support Microsoft
Dans cet exemple, la formule dans la cellule D2 déclare: SI(C2 = 1, alors renvoi Oui, sinon renvoi Non)Comme vous le voyez, la fonction SI peut être utilisée afin d’évaluer le texte et les valeurs.Elle peut également être utilisée pourévaluer des erreurs.Vous n’êtes pas limité à la vérification si un élément est égal à un autre et au renvoi à un résultat unique, vous ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
修复 Windows 中的打印机连接和打印问题 - Microsoft 支持
检查电缆(对于有线打印机)。确保打印机的 USB 电缆已从打印机正确连接到你的电脑。 如果未识别 USB,请参阅自动诊断和修复 Windows USB问题。. 检查无线连接(对于无线打印机)。
SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
ROUND 函数 - Microsoft 支持
说明. round 函数将数字四舍五入到指定的位数。 例如,如果单元格 a1 包含 23.7825,而且您想要将此数值舍入到两个小数位数,可以使用以下公式: =round(a1, 2)
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Excel 2021 for Windows 中的新增功能 - Microsoft 支持
根据你的反馈,我们在十六进制颜色值的" 颜色 "对话框中添加了一个新的输入字段。 无需将十六进制颜色值转换为 rgb 值。 对于可以定义颜色的任何属性,现在可以在 十六进制 框中输入十六进制颜色值,例如#0f4c81或 444。
Applies To: Excel 2021
使用 Excel 内置函数查找表格或单元格区域中的数据 - Microsoft 支持
功能 LOOKUP LOOKUP函数在一行或一列中查找值, 并将其与另一行或列中相同位置的值相匹配。 下面是一个查找公式语法的示例: = LOOKUP (Lookup_Value, Lookup_Vector, Result_Vector) 下面的公式在示例工作表中查找 Mary 的年龄: = LOOKUP (E2, A2: A5, C2: C5) 公式使用单元格 E2 中的值 "Mary", 在查找向量 (列 A) 中找到 "Mary"。
Applies To: Office for business