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
Send automatic replies (out of office) from Outlook
Troubleshooting: I don't see Automatic Replies. If you don't see Automatic Replies after selecting File, you're probably using a Gmail, Yahoo, or other POP or IMAP account that doesn't support the Outlook Automatic Replies feature.You can set up a rule that will reply to incoming messages—if you leave Outlook running while you're away.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Open Device Manager - Microsoft Support
In the search box on the taskbar, type device manager, then select Device Manager from the menu.
Windows 10 Update Assistant - Microsoft Support
This troubleshooter assists customers whose machines are not yet updated to the latest release, Windows 10 Version 1607. This update will initially be released only to a small set of targeted customers. This set will expand over time. Windows users can start the assistant from this article.
Activate Office - Microsoft Support
Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Install Quick Assist - Microsoft Support
To pin Quick Assist to your taskbar so you can quickly get back to it, after Quick Assist is open, right-click (or press and hold) the icon on your taskbar > Pin to taskbar. If the old app icon still appears on your device, make sure you select the new app icon.
Which version of Windows operating system am I running?
Find operating system info in Windows 8.1 or Windows RT 8.1. To find out which version of Windows your device is running, press the Windows logo key key + R, type winver in the Open box, and then select OK.. If your device is running Windows 8.1 or Windows RT 8.1, here’s how to learn more:
Back up your Windows PC - Microsoft Support
Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.
Shut down, sleep, or hibernate your PC - Microsoft Support
Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.
Get the latest Windows update - Microsoft Support
Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.