在 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
Change mouse settings - Microsoft Support
To speed up the process of selecting a choice when a dialog box appears, under Snap To, select the Automatically move pointer to the default button in a dialog box check box.(Not all programs support this setting. In some programs, you'll need to move the mouse pointer to the button you want to click.)
All about Xbox Game Pass Core | Xbox Support
Xbox Live Gold is now Game Pass Core. On September 14, 2023, Xbox Live Gold members automatically became Game Pass Core members, with no change in pricing, and gained immediate access to a new catalog of high-quality games.
How to add an email address or phone number to your Microsoft account
Tip: Creating an Outlook.com email address gives you a brand-new email address that is attached to your existing Microsoft account.This makes several benefits and features available to you within the Microsoft suite of products, particularly within Outlook. You might want to do this if your Microsoft account is not currently tied to an Outlook.com email address.
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
Create or run a macro - Microsoft Support
To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...
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
Cloud gaming with Xbox | Xbox Support
Learn about cloud gaming on Xbox using your Android, iOS, or Windows device.
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
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
How to open MSConfig in Windows 10 - Microsoft Support
Learn how to open MSConfig in Windows 10 using the taskbar search bar and access system configuration.