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
Keeping leading zeros and large numbers - Microsoft Support
Keeping leading zeros and large numbers in Excel. Use a custom format to keep the leading zeros. If you want to resolve the issue just within the workbook because it's not used by other programs as a data source, you can use a custom or a special format to keep the leading zeros.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Erstellen von Dropdownlisten - Microsoft-Support
Wählen Sie die Registerkarte Fehlerwarnung aus .. Wenn eine Nachricht angezeigt werden soll, wenn jemand etwas eingibt, das nicht in Ihrer Liste enthalten ist, aktivieren Sie das Kontrollkästchen Fehlerwarnung anzeigen, nachdem ungültige Daten eingegeben wurden , wählen Sie eine Option aus dem Feld Format aus, und geben Sie einen Titel und eine Nachricht ein.
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
Open and use a shared mailbox in Outlook - Microsoft Support
Find the shared mailbox in the folder pane. In the folder pane on the left, locate the Shared with me folder. Click the folder to expand it. Your shared mailbox is a subfolder under Shared with me.When you select the name of the shared mailbox there, it will expand to show the standard email folders, such as Inbox, Drafts, and Sent Items.. Send mail from the shared mailbox
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Common file name extensions in Windows - Microsoft Support
Extension. Format. aac, adt, adts. Windows audio file. accdb. Microsoft Access database file. accde. Microsoft Access execute-only file. accdr. Microsoft Access ...
Manage display language settings in Windows - Microsoft Support
The display language you select changes the default language used by Windows features, such as Settings and File Explorer. Select Start > Settings > Time & Language > Language.
INDEX function - Microsoft Support
Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.
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
Account has been locked - Microsoft Support
Why accounts are locked and disabled. Microsoft accounts are usually locked if the account holder has violated our Microsoft Services Agreement.Here are some common reasons why accounts are locked, though not all account locks occur for these reasons:
Cómo usar la aplicación Comprobación de estado del PC
Cómo abrir la Comprobación de estado del PC. En Windows, escribe "Comprobación de estado del PC" en el área de búsqueda de la barra de tareas y selecciónalo en la lista de resultados.
Add an email account to Outlook for Windows - Microsoft Support
Outlook won't accept my password. If you've forgotten the password for a Microsoft account, user our sign-in helper to get back into your account.. If you know you’re using the correct password for your email account but Outlook won’t accept it, you might have an email account that requires additional security.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, New Outlook for Windows