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
Using IF with AND, OR, and NOT functions in Excel
Examples. Following are examples of some common nested IF(AND()), IF(OR()) and IF(NOT()) statements in Excel. The AND and OR functions can support up to 255 individual conditions, but it’s not good practice to use more than a few because complex, nested formulas can get very difficult to build, test and maintain.
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
How to earn Microsoft Rewards points - Microsoft Support
Microsoft Rewards points don’t have any cash value. It usually takes about 5,000 points to redeem something worth $5. Learn more about redeeming Microsoft Rewards points. Microsoft Rewards points will expire if there are no earning activities within 18 months.
Applies To: Microsoft account dashboard
Download and install apps - Microsoft Support
As you're getting your Microsoft 365 business subscription set up, you'll want to download and install your Microsoft 365 apps, like Word, Excel, Microsoft Teams, and PowerPoint, on your PC or Mac.
Solve PC problems remotely with Remote Assistance and Easy Connect
To invite someone who isn't on your contact list, select Invite someone to help you. Follow the instructions. To give help if someone has requested it: Go to the search box and enter remote assistance, then select Invite someone to connect to your PC and help you, or offer to help someone else.
Use the Office offline installer - Microsoft Support
Step 2. Install Office. Select the Microsoft 365 folder from the virtual drive and then double-click either the Setup32.exe to install the 32-bit version of Microsoft 365, or Setup64.exe to install the 64-bit version to begin the offline installation. If you're not sure which version is right for you, see Choose the 64-bit or 32-bit version of Office. ...
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Fix your Outlook email connection by repairing your profile
On the Email tab, choose your account (profile), and then choose Repair.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
App permissions - Microsoft Support
Here's more info on what permissions allow an app to do: Access all your files, peripheral devices, apps, programs, and registry: The app has the ability to read or write to all your files (including documents, pictures, and music) and registry settings, which allows the app to make changes to your computer and settings. It can use any peripheral devices that are either attached or part of ...
Update Windows - Microsoft Support
Learn how to update Windows to ensure your device operates smoothly and securely with the latest features.
Find your Windows product key - Microsoft Support
Generally, if you bought a physical copy of Windows, the product key should be on a label or card inside the box that Windows came in. If Windows came preinstalled on your PC, the product key should appear on a sticker on your device. If you’ve lost or can’t find the product key, contact the manufacturer.
Applies To: Microsoft account dashboard