Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
在 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
What is Data Execution Prevention (DEP)? - Microsoft Support
Data Execution Prevention (DEP) is a technology built into Windows that helps protect you from malicious code launching from areas of memory that have been designated as for data only.
Office Lens for Windows - Microsoft Support
Office Lens is an app for all of your Windows devices. It's a great way to capture notes and info from whiteboards, menus, signs or anything with a lot of text--and even images without text.
Applies To: Office Lens for Windows
Add an exclusion to Windows Security - Microsoft Support
If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To: Microsoft Teams
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies. Sensitivity labels are configured by your administrator and because they're published to users rather than locations such as sites and mailboxes, users in the same organization might see different sensitivity labels to apply.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Word for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Outlook on the web, Excel for iPad, Word for iPad, PowerPoint for iPad, Excel for iPhone, Word for iPhone, PowerPoint for iPhone, Word for Android tablets, Excel for Android tablets, PowerPoint for Android tablets, Excel for Android phones, New Outlook for Windows, Outlook for Android, Outlook for iOS, PowerPoint for Android phones, Word for Android phones
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
Change the level of protection in the Junk Email Filter
Junk e-mail messages, also known as spam, can be a nuisance in your Inbox.The Junk E-mail Filter in Outlook identifies messages that are likely junk and moves them to the Junk E-mail folder. You can easily change the level of junk email protection or automatically delete junk email.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Show, hide, and view the Bcc (blind carbon copy) field in Outlook for ...
Know your limits Many email service providers set limits for the number of names that can be included in the To, Cc, and Bcc boxes in a message. For example, your email service provider may limit each message to a maximum of 100 email addresses. If these addresses are distributed among the To, Cc, and Bcc boxes, remember that the names in the Bcc box will count toward your total limit.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Change your profile picture in Microsoft Teams
Select your profile picture at the top right of Teams. When your account manager opens, select your profile picture again.
Applies To: Microsoft Teams