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
Fix sound or audio problems in Windows - Microsoft Support
If you’re having sound or audio problems, the following suggestions might help. The tips are listed in order, so start with the first one, see if that helps, and then continue to the next one if it doesn’t.
How to use the PC Health Check app - Microsoft Support
Note: If a compatibility issue has been identified on your device that would disrupt your experience using Windows 11, we will temporarily delay your upgrade until the issue is resolved.Compatibility safeguard holds help ensure you have the best experience possible when upgrading and your productivity is not disrupted if critical apps or drivers are not yet compatible.
How to sign in to or out of Outlook.com - Microsoft Support
Learn how to sign in or out of your Outlook.com, Hotmail, Live, or MSN email account with Microsoft Support's step-by-step guide.
Applies To: Outlook.com
Find settings in Windows - Microsoft Support
Find your Windows settings in a snap! Select the Start button, then select Settings .From there, browse the categories or use search to find what you're looking for.
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
Reset a forgotten Microsoft account password
Notes: If you know your password, but just want to change it, go to account.microsoft.com Security tab, and select Change my password. If you know your username and password but they have stopped working, read My username and password have stopped working.
Applies To: Microsoft account dashboard
Fix Bluetooth problems in Windows - Microsoft Support
Before you start. Check these things before you start troubleshooting Bluetooth on your device: Check your product information. If you’re setting up a new device and Bluetooth is missing, check the product specifications to make sure it has Bluetooth capabilities.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Manage your Microsoft 365 subscription or Office product
You can manage all of your Microsoft subscriptions in your Microsoft account dashboard. Select each subscription to change when and how you pay, or to see order history & receipts.
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 for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows