Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
WENN-Funktion – Geschachtelte Formeln und das Vermeiden von Fallgruben
Hinweise. Excel erlaubt zwar das Schachteln von bis zu 64 unterschiedlichen WENN-Funktionen, dennoch ist das nicht ratsam. Warum? Mehrere WENN-Anweisungen erfordern ein hohes Maß an Konzentration, um korrekt erstellt zu werden und um sicherzustellen, dass deren Logik über jede Bedingung bis zum Schluss ordnungsgemäß berechnet wird.
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
在电脑或 Mac 上下载并安装或重新安装 Microsoft 365 或 Office 2021 - Microsoft 支持
准备好安装了吗? 在开始之前,请确保电脑或 Mac 满足 系统要求。. 如果你已兑换产品密钥,只需重新安装应用,或者知道你已通过工作或学校分配了许可证,则可以跳到登录部分 ,下载并安装 Microsoft 365 或 Office。 但是,如果是 首次 安装 Microsoft 365 或 Office,可能需要先执行一些步骤。
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin, Office.com
Tips to free up drive space on your PC - Microsoft Support
Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)
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
Outline (group) data in a worksheet - Microsoft Support
If you want, your grouped detail rows can have a corresponding summary row—a subtotal. To create these, do one of the following: Insert summary rows by using the Subtotal command . Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For more information about using the Subtotal ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Sharing your Xbox Game Pass subscription | Xbox Support
Find out how to use your Xbox Game Pass membership to share the benefits with your friends on any Xbox console.
Outlook on the web にサインインする方法 - Microsoft サポート
注: 職場または学校アカウントではなく、 Outlook.com、Hotmail、Live、MSN のメール アカウントなどの Microsoft アカウントでサインインした場合は、サインアウトしてから、正しいアカウントを使用してもう一度サインインします。 サインインしているアカウントがわからない場合 Outlook ...
Applies To: Office for business, Office 365 Small Business, Outlook on the web, Outlook on the web for Exchange Server 2016
Create an email message template - Microsoft Support
In the Save As dialog box, in the Save as type list, select Outlook Template.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
TEXT function - Microsoft Support
Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.
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
Stay safe with a genuine Office license - Microsoft Support
Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.
Applies To: Office 2019