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
Die WENN-Funktion ermöglicht einen logischen Vergleich zwischen einem aktuellen Wert und einem erwarteten Wert. Dazu wird auf eine Bedingung geprüft und ein Ergebnis zurückgegeben, wenn der Wert wahr oder falsch ist. WENN (ein Wert wahr ist, tue dieses, andernfalls tue etwas anderes) Daher kann eine WENN-Anweisung zwei Ergebnisse haben.
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
Passkeys overview - Microsoft Support
Passkeys are the future of authentication, and for good reason! They're incredibly easy to use and intuitive, eliminating the need for complicated password creation processes and the hassle of remembering them. Plus, they're unique to each website or application, so you don't have to worry about someone using your passkey to access other services.
Use Smart charging in Windows - Microsoft Support
When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.
Disk cleanup in Windows - Microsoft Support
Select the drive you want to clean up, and then select OK. Under Files to delete, select the file types to get rid of. To get a description of the file type, select it. Select OK. If you need to free up more space, you can also delete system files: In Disk Cleanup, select Clean up system files. Select the file types to get rid of.
打开或关闭 Microsoft Defender 防火墙 - Microsoft 支持
若要打开或关闭 Microsoft Defender 防火墙,请执行以下操作:. Windows 11 Windows 10. 选择“ 开始 ” ,然后打开“ 设置 ” 。. 在“ 隐私和安全 ” 下面,选择“ Windows 安全 ” >“ 防火墙和网络保护 ”。. 打开 Windows 安全中心设置. 选择网络配置文件: 域网络 、 专用 ...
フォームまたはコントロール ボタンにマクロを割り当てる - Microsoft サポート
フォーム コントロール ボタンまたはコマンド ボタン (ActiveX コントロール) を使用して、ユーザーがクリックしたときにアクションを実行するマクロを実行できます。. どちらのボタンもプッシュ ボタンと呼ばれ、ワークシートの印刷、データのフィルター ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
Enable TPM 2.0 on your PC - Microsoft Support
If it is less than 2.0, your device does not meet the Windows 11 requirements. Option 2: Use the Microsoft Management Console. Press [ Windows Key] + R or select Start > Run. Type “tpm.msc” (do not use quotation marks) and choose OK. If you see a message saying a “Compatible TPM cannot be found,” your PC may have a TPM that is disabled.
Change your default search engine in Microsoft Edge
Keeping Bing as your default search engine provides an enhanced search experience in the new Microsoft Edge , including direct links to Windows apps, relevant suggestions from your organization if you’re signed in with a work or school account, and instant answers to questions about Windows.However, you can change the default search engine to any site that uses OpenSearch technology.
IF 函数 - 嵌套公式和避免错误 - Microsoft 支持
备注. 虽然 Excel 允许嵌套最多 64 个不同的 IF 函数,但不建议这样做。 原因如下。 要正确地构建多个 IF 语句需要花大量心思,并要确保其逻辑在直至结尾的每个条件下都能计算正确。
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
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones