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
Format text as superscript or subscript in Word - Microsoft Support
For superscript, press Ctrl, Shift, and the Plus sign (+) at the same time. For subscript, press Ctrl and the Equal sign (=) at the same time. (Do not press Shift.)
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
How to recover a hacked or compromised Microsoft account
If your account has been hacked, use our sign-in helper tool below to help guide you to the right solutions. The tool will ask for your email address or phone number, and either show appropriate self-help, or offer the chance to talk to an agent.
Keyboard shortcut for print screen - Microsoft Support
Depending on your hardware, you may use the Windows Logo Key + PrtScn button as a shortcut for print screen. If your device does not have the PrtScn button, you may use Fn + Windows logo key + Space Bar to take a screenshot, which can then be printed.. To locate your screenshots, open File Explorer from the taskbar. On the side navigation pane, select the Pictures folder, and select Screenshots.
Change the level of protection in the Junk Email Filter
Junk e-mail messages, also known as spam, can be a nuisance in your Inbox.The Junk E-mail Filter in Outlook identifies messages that are likely junk and moves them to the Junk E-mail folder. You can easily change the level of junk email protection or automatically delete junk email.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
How to recover missing, deleted or corrupted items in SharePoint and ...
Problem. In SharePoint or OneDrive, you experience one or more of the following problem scenarios: Scenario 1: You're missing a file, folder, or item from a list or library.
Applies To: SharePoint in Microsoft 365, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
"Sorry, something's wrong with your Microsoft account" error occurs ...
The security info that you replaced will be deleted in 30 days. During that time, we'll send notifications to the phone number or email address that's being removed, in case an attacker is attempting to remove your info.
Create an Xbox profile | Xbox Support
If you already have a Microsoft account that you use to sign in to other Microsoft services (such as Windows, Outlook, OneDrive, Office, MSN, and Skype), use that account to create your Xbox account as well.
Change or set the default font in Outlook - Microsoft Support
Replying or forwarding messages - You can have a different font on messages you're forwarding or replying to. This setting is mostly for the two check boxes that let you mark your comments with your name (or other text) or with a different color of text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
How to add, modify, or delete registry subkeys and values by using a ...
For more information about registry data types, click the following article number to view the article in the Microsoft Knowledge Base: 256986 Description of the Microsoft Windows registry DataValuex immediately follows the colon (or the equal sign with REG_SZ) and must be in the appropriate format (for example, string or hexadecimal). Use hexadecimal format for binary data items.