IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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
Use the News web part on a SharePoint page - Microsoft Support
News sources. When you are working with a News web part, you can specify the source for your news posts. Your news posts can come from the site you are on while using the web part (This site), a hub site that the current site is part of (All sites in the hub), or one or more individual sites (Select sites).Another option is to choose Recommended for current user, which will display posts for ...
Applies To: SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint admin center, SharePoint operated by 21Vianet
Create a poll in Outlook - Microsoft Support
Check your poll results. You can see aggregated results in the voting card that is in the body of the email. Click Refresh to see the most updated results or click View in Forms to see detailed responses on forms.office.com.Similarly, you can click on the poll link in the body of the email to track more detailed results on forms.office.com.. Feedback for Microsoft Forms
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook.com, Microsoft Forms
Microsoft account security info & verification codes
Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).
Applies To: Microsoft account dashboard
Fill data automatically in worksheet cells - Microsoft Support
Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
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
Account & profile | Xbox Support
Find everything you need to manage your Xbox account, profile, and more.
Use Favorites in Outlook - Microsoft Support
When a folder is added to Favorites, it’s a shortcut to the folder.The actual folder and its content remains at the original location in the folder list. Removing a folder from Favorites doesn’t delete the folder or contents—it removes only the shortcut that appears in Favorites.. By default, when a folder is added to Favorites, it appears at the bottom of the list.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows