在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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, Excel for Windows Phone 10
File sharing over a network in Windows - Microsoft Support
Learn about file sharing over a network in Windows. Note: This article focuses on how to share files or folders over a Local Area Network (or LAN), such as connected computers within your home or workplace.If you are trying to find out how to share a file over the Internet, for example with a friend or family member, OneDrive provides easy ways to accomplish this.
Introducing Microsoft Phone Link and Link to Windows
We want to hear from you! Please continue to share your feedback with us — either in the Google Play Store, directly in the Phone Link and Link to Windows apps, or at the bottom of this article.
Get new themes and desktop backgrounds - Microsoft Support
Select Start , then select Settings > Personalization > Themes.Choose from a default theme or select Get more themes in Microsoft Store if you want to download new themes with desktop backgrounds that feature cute critters, breathtaking landscapes, and other smile-inducing options.
TEXT function - Microsoft Support
Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.
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
Get a personalized email address in Microsoft 365
Tip: If you have a Microsoft 365 Family subscription, people you've shared the subscription with can also set up a personalized email address with your connected domain.After you've set up your domain, people you've shared with will see an option to add a personalized email address in the premium features section of Outlook settings.
Applies To: Outlook.com
Baixe e instale ou reinstale o Microsoft 365 ou o Office 2021 em um ...
* Se você não tiver uma chave do produto (Product Key) ou uma conta. Algumas versões do Microsoft 365, como Office Professional Plus 2021, Office Standard 2021, ou um aplicativo autônomo, como Word 2021 ou Project 2021, não têm uma conta Microsoft associada, ou uma conta corporativa ou de estudante.. As etapas para instalar essas versões podem ser diferentes, dependendo se você obteve ...
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Office.com
Repair apps and programs in Windows - Microsoft Support
Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.
Fix your Outlook email connection by repairing your profile
On the Email tab, choose your account (profile), and then choose Repair.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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