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
Add an email account to Outlook - Microsoft Support
Enter your email address and select Connect.. If your screen looks different, enter your name, email address, and password, and select Next.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create a drop-down list - Microsoft Support
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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
Fix common Surface problems using the Surface app and Surface ...
The toolkit checks for updates and checks different parts of your Surface. You can skip the tests that don't apply to your issue. Tests include:
Use add-ins in Outlook - Microsoft Support
Notes: Starting in Outlook for Windows Version 2303 (Build 16215.10000), the All Apps button replaces the Get Add-ins buttonon the ribbon to view installed add-ins and access the Office Store.If you’re using an earlier version of Outlook, you'll see the Get Add-ins button instead.. If you don't see All Apps on the ribbon, your administrator may have turned off add-ins for your organization.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows, Outlook Web App
Archive items manually - Microsoft Support
Your Outlook mailbox is only so big, and it’s a good bet that you won’t stop getting email anytime soon. To keep it from filling up, you can move old items you want to keep to an archive, a separate Outlook Data File (.pst) that you can open from Outlook any time you need it.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
How to open Microsoft Store on Windows - Microsoft Support
Learn how to access Microsoft Store on Windows by selecting the icon on the taskbar or using the search box.
Applies To: Microsoft account dashboard
Compare Outlook for PC, Outlook on the web, and Outlook for iOS ...
Outlook. Outlook on the web. Mail and Calendar. Available for purchase as part of Microsoft 365 or Microsoft 365. Accessible from most browsers at Microsoft 365 portal.. Available for iOS and Android devices.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook.com
Encrypt email messages - Microsoft Support
When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create, change, or customize a view - Microsoft Support
For more details about dark mode, see Dark Mode in Outlook.. Types of views. There are several different types of views you can choose when creating new view. Table A table view shows your information in rows and columns.This is one of the most effective views for email messages.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016