在 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
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Import photos and videos - Microsoft Support
Note for iPhone: If you are having trouble with your iPhone import, make sure your device is unlocked and you’ve accepted the permissions. Note for Android and other devices: If you’re using an Android phone or other device and import isn’t working, you might need to change your phone’s USB settings from Charging over USB to Transfer Files or Transfer Photos.
Solve PC problems remotely with Remote Assistance and Easy Connect
Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business
Recover lost or deleted files - Microsoft Support
If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version.Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.
Latest updates for Microsoft Copilot - Microsoft Support
As your everyday AI companion, Microsoft Copilot assists you with everything from starting with a blank page to finding the perfect words. It simplifies tasks, boosting your productivity and ensuring you focus on what matters most.
Change or update your email password - Microsoft Support
Change your password with your email provider. See the following sections for instructions on changing your email account password for several major email providers.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, New Outlook for Windows
Rewards on Xbox - Microsoft Support
Earn Microsoft Rewards points with Xbox, whether on console or on your devices. Available with your Microsoft account, the free Microsoft Rewards program makes it even easier to earn points for things you already do, like shopping for games and other eligible items in the Microsoft Store, gaming on Xbox, or searching on Bing.
Excel video training - Microsoft Support
Learn Excel skills from beginner to advanced with video tutorials, templates, and tips from Microsoft Support.
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 2016