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

Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

You can also use the keyboard to browse through features and change feature options. Use the UP ARROW and DOWN ARROW keys to select features. Use the RIGHT ARROW key to expand a feature that contains one or more sub-features.

Get to know common Windows keyboard shortcuts including copy, cut, paste, maximize a window, and more.

Notes: Starting in Outlook for Windows Version 2303 (Build 16215.10000), the All Apps button replaces the Get Add-ins buttonon the ribbon to view installed add-ins and access the Office Store.If you’re using an earlier version of Outlook, you'll see the Get Add-ins button instead.. If you don't see All Apps on the ribbon, your administrator may have turned off add-ins for your organization.

Select the Action tab at the top of the window.Select Disable device or Enable device, and then confirm.If there's more than one HID-compliant touchscreen device listed, perform steps 2–3 for that one too.

Note: If you selected Delete unread copies and replace with a new message, the original message opens for editing.When you select Send, the original email message will be deleted from the recipient’s mailbox and replaced with the newly edited one.

Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.

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.)