IF function - Microsoft Support
In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...
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
Share and access a view-only calendar in Outlook
Notes: If your email account uses Exchange, you will see Publish This Calendar, instead of the option to publish to a WebDAV server.This lets you publish your calendar directly to an Exchange Server. In the window that opens, select the publishing options you want, and click Start Publishing.. If you're using Microsoft 365, you can still publish your calendar to a WebDAV server, but you must ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
I forgot the account I use with Microsoft 365 - Microsoft Support
Microsoft 365 for business. If your Microsoft 365 product is one of the following, you have a Microsoft 365 for business product. These products are usually associated with a work or school account, and your Microsoft 365 license (if your subscription has one) came from the organization where you work or go to school.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook 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, OneNote for Microsoft 365 for Mac, 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, 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, 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, OneNote for Mac, SharePoint in Microsoft 365, 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, Microsoft 365 for Mac, Office 365 Activation, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Project for Office 365
Troubleshoot external monitor connections in Windows 10
Troubleshoot issues that occur when setting up external monitors. If you are trying to set up an external monitor and it’s not working, press the Windows logo key + P to make sure that the Extend option is selected. If the Extend option is selected, try the following troubleshooting tips.
Find your IP address in Windows - Microsoft Support
For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to.
Create, edit, or delete a contact list or contact group in Outlook
You can right-click the contact group and select Delete from the menu or click the group, then select Delete from the Ribbon.. Contacts are not deleted, only the contact list.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Manage notifications in Microsoft Teams - Microsoft Support
Missed activity emails. In the Missed activity emails section, you’re able to set the frequency of summary emails detailing your missed activity, or turn this feature off.. Chats and channels notifications. Notifications for chats and channels can be managed at a granular level, allowing you to customize your notifications to your personal work style.
Applies To: Microsoft Teams
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 ...
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To: Office 2021, Office 2021 for Mac
LOOKUP function - Microsoft Support
The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array. Use this form of LOOKUP when the values that you want to match are in the first row or column of the array.. Syntax. LOOKUP(lookup_value, array) The LOOKUP function array form syntax has these arguments:
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