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
Use a proxy server in Windows - Microsoft Support
If you don’t want to use the proxy server when you visit certain websites, enter the ending of the website address in the exception list (for example, *.contoso.com). For multiple websites, type each website address and separate the addresses with a semicolon (for example: *.contoso.com; *.adatum.com).The * is a wildcard so any website addresses that end with the website address listed will ...
Share and access a calendar with edit or delegate permissions in ...
After you’ve finished adding the person you want to share your calendar with and have chosen which permission you want to give them, select Share.If you decide not to share your calendar right now, select Remove.. The person you shared your calendar with will receive an email message telling them about it.
Applies To:
Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.
Applies To:
Microsoft account dashboard
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Manage email messages by using rules in Outlook - Microsoft Support
Edit an inbox rule in Outlook on the web. You can edit any inbox rule by selecting it and choosing Edit rule to open the rule so that you can change the conditions or actions of the rule.. Delete an inbox rule in Outlook on the web
Applies To:
Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook Web App
Where to enter your Office product key - Microsoft Support
These steps apply only to Office Professional Plus, Visio Professional, or Project Professional. Step 1: Start an Office app, like Word, Project, or Visio, depending on your purchase.. Step 2: In the Sign in to set up Office window, select I don't want to sign in or create an account (it's a small link at the bottom of the window).. Step 3: Enter your Office product key, without hyphens.
Applies To:
Office 2024, Office 2024 for Mac, Office 2021, Office 2021 for Mac, Office 2019, Office 2016, Microsoft 365 for home, Office for business
Request a refund for digital games | Xbox Support
Refunds are typically issued for requests meeting the following criteria: Requests are made within 14 days of the purchase date; Requests are for games in which you haven’t accumulated a significant amount of play time
Remove malware from your Windows PC - Microsoft Support
Learn how to remove malware from your PC. Use Microsoft Defender Antivirus in Windows 10 or Windows 11 to scan your PC for malware, viruses, or other threats.
Applies To:
OneDrive (home or personal), OneDrive for Windows