Using IF with AND, OR, and NOT functions in Excel
=IF(A2>B2,TRUE,FALSE) IF A2 is greater than B2, return TRUE, otherwise return FALSE. 03/12/14 is greater than 01/01/14, so the formula returns TRUE. =IF(AND(A3>B2,A3<C2),TRUE,FALSE) IF A3 is greater than B2 AND A3 is less than C2, return TRUE, otherwise return FALSE. In this case both arguments are true, so the formula returns TRUE.
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
Redeem a gift card or code to your Microsoft account
How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.
Applies To:
Microsoft account dashboard
Keyboard shortcuts to add language accent marks in Word and Outlook ...
Alt+0299. Alt+0332. Alt+0333. Alt+0362. Alt+0363. Notes: If you're working on a laptop without a separate numeric keyboard, you can add most accented characters using the Insert > Symbol > More Symbols command in Word. For more info, see Insert a symbol in Word.
Applies To:
Word for Microsoft 365, Outlook for Microsoft 365, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
Request a refund for digital games | Xbox Support
Refunds are typically issued for requests meeting the following criteria: Requests are made within 14 days of the purchase date. Requests are for games in which you haven’t accumulated a significant amount of play time. Note As a limited exception, digital game products may be eligible for a refund within 30 days if you’re unsatisfied with ...
Overview of formulas - Microsoft Support
=A1+A2+A3 Adds the values in cells A1, A2, and A3. =SQRT(A1) ... B7:D7 C6:C8. The order in which Excel for the web performs operations in formulas. In some cases, the order in which a calculation is performed can affect the return value of the formula, so it's important to understand how the order is determined and how you can change the order ...
Applies To:
Excel for the web
修复 Office 应用程序 - Microsoft 支持
Windows 10 Windows 11. 访问修复工具的步骤因操作系统的不同而异。. 右键单击左下角) ( “开始” 按钮，然后在弹出菜单中选择“ 应用和功能 ”。. 选择要修复的 Microsoft Office 产品，然后选择“ 修改 ”。. 注意: 即使要修复的只是一个应用程序（如 Word 或 Excel），此 ...
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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
連結專案中的任務 - Microsoft Support
若要移除連結，請選取兩個連結的工作，然後選擇 [ 任務 > 取消連結任務] 。 根據預設，Project 會建立簡單的 完成-開始 任務連結，這表示第一個任務 ( 前置任務) 必須先完成，第二個任務 ( 後續任務) 才能開始。. 如果您是 Project Online 訂閱者，您也可以從 [前置任務] 或 [後續任務] 欄中，選取要連結 ...
Applies To:
Project Online Desktop Client, Project Professional 2021, Project Standard 2021, Project Professional 2019, Project Standard 2019, Project Professional 2016, Project Standard 2016
Getting the most out of your PC backup - Microsoft Support
Getting the most out of your PC backup. When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier. Your Microsoft account ties everything together, no matter where you are or what ...
Use Snipping Tool to capture screenshots - Microsoft Support
There are four ways to open Snipping Tool: Select the Start button, enter snipping tool, then select Snipping Tool from the results. Press Windows logo key + Shift + S for a static image snip. Press Print Screen ( PrtSc ) for a static image snip. Press Windows logo key + Shift + R for a video snip.