在 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
Snap your windows - Microsoft Support
The Snap feature is a great way to improve your productivity by sharing many app windows in a single screen. Different layouts are available with many sizes to choose from, so you can get the most from your favorite apps when you are working on specific tasks.
I can't sign in to my Microsoft account - Microsoft Support
If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, GroupMe, Microsoft account dashboard, Microsoft Teams, Microsoft Teams personal, Microsoft To Do, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, Outlook for Android, Outlook for iOS
Receive files over Bluetooth - Microsoft Support
Receive photos, videos, or other kinds of files that you or a friend shares from another device, such as a phone, laptop, or tablet. On your PC, select Start > Settings > Devices > Bluetooth & other devices. Learn how to pair.
Get help with a digital code or gift card | Xbox Support
All Xbox digital codes are 25 characters long, include both numbers and letters, and are formatted in five blocks of five characters (xxxxx-xxxxx-xxxxx-xxxxx-xxxxx).
Troubleshoot screen flickering in Windows - Microsoft Support
Press Ctrl + Alt + Delete to open Task Manager.If you don’t see Task Manager after pressing Ctrl + Alt + Delete, press Ctrl + Shift + Esc to open Task Manager.. If Task Manager flickers along with everything else on the screen, a display driver is probably causing the problem.
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
KB4023057: Update Health Tools—Windows Update Service components
Important: If your device is out of support, it is no longer receiving security updates from Microsoft and may become more vulnerable to security risks and viruses.Therefore, we strongly recommend that you update to the latest version of Windows. Each version of Windows is supported for 18 months.
Turn off Scroll Lock - Microsoft Support
Tip: To quickly open the On-screen Keyboard in Windows 11, click the Windows button.Begin typing On-Screen Keyboard which will appear in the search entry box. Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. When the on-screen keyboard appears, click the ScrLk button.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
I can’t start Microsoft Outlook or receive the error “Cannot start ...
Sometimes add-ins can conflict with Outlook. Starting Outlook in safe mode, which starts Outlook without add-ins loaded, can tell you if an add-in is the source of the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin