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
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
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Customer service phone numbers - Microsoft Support
Country/Region. Country/Region code. Phone number. Language. Toll. Anguilla +1 264 +1. 866 993 9330. 305 418 9136. English / Español. Toll free. Toll. Antigua & Barbuda
Contact Us - Microsoft Support
Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.
How to sign in to or out of Outlook.com - Microsoft Support
Note: Check the Don't show this again box if you want to go straight to Outlook.com next time (not recommended for shared computers).
Applies To: Outlook.com
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 2024, Excel 2021, Excel 2019, Excel 2016
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
Feature comparison between new Outlook and classic Outlook
Feature. Classic Outlook. New Outlook. Help article. 3-day calendar view. Available. Available. Change how you view your calendar. Add attendees as optional. Available
Applies To: Outlook for Microsoft 365, New Outlook for Windows
How to sign out of your Microsoft account everywhere
If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.
Applies To: Microsoft account dashboard