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.
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 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
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
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
Accessing Credential Manager - Microsoft Support
Credential Manager lets you view and delete your saved credentials for signing in to websites, connected applications, and networks. To open Credential Manager, type credential manager in the search box on the taskbar and select Credential Manager Control panel.
Reset OneDrive - Microsoft Support
Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Use Snipping Tool to capture screenshots - Microsoft Support
To capture a video snip, open Snipping Tool, select the Record button, then select New recording, or press Windows logo key + Shift + R.Select the area of the screen you wish to record, then select Start.When you are done, select Stop.At this point you can save the recording as-is or select Edit in Clipchamp to work with it in the Clipchamp video editor.
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Create and format a hard disk partition - Microsoft Support
To create a partition or volume (the two terms are often used interchangeably) on a hard disk, you must be logged in as an administrator, and there must be either unallocated disk space or free space within an extended partition on the hard disk.
Connect to a VPN in Windows - Microsoft Support
Whether it's for work or personal use, you can connect to a virtual private network (VPN) on your Windows PC. A VPN connection can help provide a more secure connection and access to your company's network and the internet, for example, when you’re working from a coffee shop or similar public place.
Pin, remove, and customize in Quick access - Microsoft Support
By default, File Explorer opens to Quick Access. You can set a folder to show up in Quick access so it'll be easy to find. Just right-click (or long-press) it and select Pin to Quick access. Unpin it when you don’t need it there anymore by right-clicking (or long-pressing) it and selecting Unpin from Quick access.. If you want to see only your pinned folders, you can turn off recent files or ...
Update your security processor (TPM) firmware - Microsoft Support
2. Install any applicable firmware updates. If you have a Surface device, see Security issue for TPM on Surface devices for more information and instructions.. If your device is not from Microsoft, locate the device manufacturer of your device in the following table, select the corresponding link, and apply the firmware update that's provide.