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 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel Web App, Excel for Windows Phone 10
Enable and disable your touchscreen in Windows - Microsoft Support
Select the Action tab at the top of the window.Select Disable device or Enable device, and then confirm.If there's more than one HID-compliant touchscreen device listed, perform steps 2–3 for that one too.
Comment utiliser l’application Contrôle d’intégrité du PC
Si votre PC fonctionne actuellement sous Windows 10, l’application Contrôle d'intégrité du PC vous permet d’effectuer une vérification complète de l’éligibilité de votre appareil afin de vous assurer qu’il répond à la configuration minimale requise pour Windows 11. Vous obtenez des informations sur la raison pour laquelle votre appareil est éligible ou non, ainsi que des ...
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
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.
Change the email address or phone number for your Microsoft account
Email addresses and phone numbers associated with your Microsoft account are called aliases and they use the same contacts, online storage, subscriptions, and account settings.
Applies To:
Microsoft account dashboard
Can my PC run Windows 11? - Microsoft Support
Your PC can run Windows 11 if it meets minimum (basic) system requirements. For information on basic system requirements and additional requirements for specific features, see Find Windows 11 specs, features, and computer requirements.
How to use Remote Desktop - Microsoft Support
Learn how to use Remote Desktop in Windows. On your Windows, macOS or iOS device: Open the Windows app (available for free from Microsoft Store and the Apple App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Pair a Bluetooth device in Windows - Microsoft Support
In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar.Select Bluetooth to turn it on. If it's turned on without any Bluetooth devices connected, it might appear as Not connected . If you don't see Bluetooth in quick settings, you might need to add it.