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.
IF function - Microsoft Support
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 ...
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
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a 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
Show or hide gridlines on a worksheet - Microsoft Support
Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel. Gridlines are always applied to the whole worksheet or workbook, and can't be applied to specific cells or ranges.
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
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
激活 Windows - Microsoft 支持
若要在 Windows 11 中检查激活状态,请选择“开始 ”按钮,然后选择“设置 > 系统 ” ,然后选择“激活 ”。 。 激活状态将在“激活”旁边列出。 在“设置”中检查激活状态. 你将在“激活”页面上看到以下一条激活状态消息:
在 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
Pin apps and folders to the desktop or taskbar - Microsoft Support
To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar.
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Change your app recommendation settings in Windows
Next to Choose where to get apps, select one of the available options.To see recommendations, select Anywhere, but let me know if there's a comparable app in the Microsoft Store.. To stop seeing app recommendations, select Anywhere.