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
Verwalten von Benutzerkonten in Windows - Microsoft-Support
Wichtig: Sie sollten die Anzahl der Administratoren auf Ihrem Windows-Gerät begrenzen, da Administratoren die vollständige Kontrolle über das System haben.Administratoren können Einstellungen ändern, Software installieren und auf alle Dateien zugreifen. Wenn zu viele Personen über diese Zugriffsebene verfügen, kann dies zu Sicherheitsrisiken wie der Installation von Schadsoftware oder ...
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
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 2021, Outlook 2019, Outlook 2016, Outlook 2013
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
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
View and delete your browsing history in Internet Explorer
Select the History tab, and choose how you want to view your history by selecting a filter from the menu.To delete specific sites, right-click a site from any of these lists and then select Delete.Or, return to a page by selecting any site in the list.
Description of Microsoft System Information (Msinfo32.exe) Tool
Examples To view your System Information, type: msinfo32 To create an .nfo file in the folder C:\Temp with a name of Test.nfo, type:. msinfo32 /nfo C:\TEMP\TEST.NFO To create a .txt file in the folder C:\Temp with a name of Test.txt, type:. msinfo32 /report C:\TEMP\TEST.TXT To view System Information from a remote computer with a UNC name of BIGSERVER, type:
SUMPRODUCT function - Microsoft Support
The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:
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
Filter websites and searches using Microsoft Family Safety
Establishing internet boundaries is an important way to protect yourself and your family from inappropriate web content. Microsoft Family Safety web and search filters work across any Windows, Xbox and mobile device that has the Microsoft Edge browser and Family Safety apps installed.
Applies To: Microsoft Family Safety