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
DATEDIF function - Microsoft Support
Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3.The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.
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, SharePoint Foundation 2010, SharePoint Server 2010, Windows SharePoint Services 3.0
Video: What is OneDrive? (personal) - Microsoft Support
Training: Microsoft OneDrive lets you store your personal photos, files, and folders in one place, and get to them anytime, anywhere. Learn more in this online training video.
Applies To:
OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Create, change, or customize a view - Microsoft Support
Views give you different ways to look at items in a folder. Each Outlook folder, such as Inbox and Calendar, allows you to customize your view to change fonts, the organization of items, and many other settings.. What would you like to do? Remove the dark background
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Change the line spacing in Word - Microsoft Support
To return to the original settings later, go to Design > Paragraph Spacing and choose the option under Style Set.This may be Default or the name of style you’re currently using.. Change the line spacing in a portion of the document. Select one or more paragraphs to update.
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
Get started with Copilot in Excel - Microsoft Support
Microsoft Copilot in Excel helps you do more with your data in Excel tables by generating formula column suggestions, showing insights in charts and PivotTables, and highlighting interesting portions of data.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for iPad, Excel Web App
Set up a security key as your verification method
What is a security key? We currently support several designs and providers of security keys using the Fast Identity Online (FIDO2) passwordless authentication protocols. These keys allow you to sign in to your work or school account to access your organization's cloud-based resources when on a supported device and web browser.
Insert a section break - Microsoft Support
Add section break to customize your document's headers and footers, format, layout, and page numbering.
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
在 Windows 中以安全模式启动电脑 - Microsoft 支持
通过使用一组有限的文件和驱动程序，安全模式可使 Windows 在基本状态下启动。 如果在安全模式下没有出现问题，你就会知道默认设置和基本设备驱动程序不是导致此问题的原因。
Manually add an account to the Microsoft Authenticator app
If your camera is unable to capture the QR code, you can manually add your account information to the Microsoft Authenticator app for two-factor verification.