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 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Mailbox storage limits in Outlook - Microsoft Support
Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.
Applies To: Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Restrictions and limitations in OneDrive and SharePoint
What's new. 1 May 2023: Updated invalid characters and invalid file and folder names. 12 April 2021: Added 50,000 item sharing limits note.. 3 March 2021: Maximum file upload size updated to 250 GB.. 16 September 2020: Updated info about OneNote notebooks to clarify that the 2GB file size limit applies to SharePoint as well as OneDrive. 31 August 2020: Updated the invalid or blocked file types ...
Applies To: SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Share your Microsoft 365 Family subscription - Microsoft Support
Sharing is only possible if the invitee joins the subscription owners' family group. If the invitee is already in another family group, they will need to leave it to join the subscription owners' family group.. Once the invitee has joined the family group, then the subscription owner can share the Microsoft 365 Family benefits.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Microsoft account dashboard
Add or remove a digital signature for Microsoft 365 files
Invisible digital signatures in Word, Excel, or PowerPoint. An invisible digital signature, like a visible digital signature line, assures the authenticity, integrity, and origin of a document.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2024, PowerPoint 2024, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Location and privacy in Microsoft Edge - Microsoft Support
How Microsoft Edge interacts with operating system permissions when sharing your location with a website. Windows can use information such as your IP address, nearby Wi-Fi access points, and GPS data, if available, to estimate your precise or imprecise location coordinates and pass this info to Microsoft Edge.
Applies To: Microsoft account dashboard
Back up your BitLocker recovery key - Microsoft Support
If you’re using a device that’s managed by your work or school, the BitLocker recovery key is typically backed up and managed by your organization’s IT department.
Learn more about sharing your Microsoft 365 Family subscription
If you've purchased Microsoft 365 Family, you can share your subscription benefits with up to five other people. For details, see Share your Microsoft 365 Family subscription.. Common questions about sharing
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Microsoft 365 for home, Microsoft 365 for Mac, Microsoft account dashboard
Get help with your Microsoft account - Microsoft Support
Learn how to get Microsoft account help, troubleshoot sign in issues, keep your account secure, and manage your Microsoft account dashboard.
Applies To: Microsoft account dashboard
Change your profile photo - Microsoft Support
Note: If you don’t see the Change link, it may be because some information, such as your name, photo, or title, is collected from systems that your IT or human resources department control.If you want to update those details, contact your administrator. If you need help finding your administrator, see How do I find out who my admin is?
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016