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
Sign in to SharePoint - Microsoft Support
In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365
Use Microsoft Authenticator with Microsoft 365
Choose the mobile app. Open a browser on your computer and go to portal.office.com.Sign in to your Office 365 for business account.
Applies To: Office for business, Microsoft 365 admin
Surface Pro (5th Gen) specs and features - Microsoft Support
Surface Pro (5th Gen) and Windows 10. Surface Pro (5th Gen) comes with Windows 10 Pro edition. If you're not sure which Surface model you're using, see Which Surface model do I have?. Diagrams of Surface Pro (5th Gen)
Managing parental consent - Microsoft Support
Helping users safely navigate web, app, and game content is one of Microsoft’s top priorities. If you live in a region that requires permission to create an account and access Microsoft services, you may be prompted to request or give parental consent.
Applies To: Microsoft account dashboard
Show or hide the ribbon in Office - Microsoft Support
Choose an option for the ribbon: Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.. Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.. Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select the ellipsis (...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016
Fix problems with apps from Microsoft Store
See also. If you can't find Microsoft Store, see Trouble finding Microsoft Store in Windows 10. If you're having trouble launching Microsoft Store, see Microsoft Store doesn't launch. If you can launch the Microsoft Store but you are just having trouble finding or installing an app, see I can't find or install an app from Microsoft Store. Need more help?
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
Help with Microsoft Store purchases - Microsoft Support
Country/region. Microsoft Store sales support. Technical or download support. Egypt +20 2 353 3333. Technical support. South Africa. 0800 167 344. Technical support
Applies To: Microsoft account dashboard
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365