但如果需要测试多个条件，例如我们假设所有条件都需要为 True 或 False (AND)，或只有一个条件需要为 True 或 False (OR)，或者如果想要检查某个条件是否不 (NOT) 符合你的条件，这时该怎么做呢？这三个函数均可以单独使用，但它们更常见于与 IF 函数成对使用。

Note: The steps to install the 2019, 2016, or 2013 versions of Office Professional Plus, Office Standard, or a stand-alone app such as Word or Project might be different if you got Microsoft 365 through one of the following: Microsoft Workplace Discount Program (formerly known as Home Use Program): If you bought Microsoft 365 for personal use through your company, see Install Office through ...

If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...

Use the Block or Allow settings to help control unwanted and unsolicited email messages by creating and managing lists of email addresses and domains that you trust and those that you don’t.

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.

In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...

To add a person to the Safe Senders List, click a message from the sender. On the Home tab, in the Delete group, click Junk, and then click Never Block Sender.. To add a specific address or domain to the Safe Recipients List, click a message from the sender.

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Whether you're at home, work, or out and about, chances are you'll find a Wi-Fi network that you can connect to for internet access. Select the Network, Sound, or Battery icons ( ) on the far right side of the taskbar to open quick settings. The Disconnected icon appears when you’re not connected.