IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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
DATE function - Microsoft Support
The DATE function returns the sequential serial number that represents a particular date.. Syntax: DATE(year,month,day) The DATE function syntax has the following arguments: Year Required.The value of the year argument can include one to four digits. Excel interprets the year argument according to the date system your computer is using. By default, Microsoft Excel for Windows uses the 1900 ...
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
Windows 的键盘快捷方式 - Microsoft 支持
键盘快捷方式是键或键组合,提供了一种替代通常使用鼠标完成的任务的替代方法。 如果要拍摄屏幕截图或截屏,请参阅 如何获取屏幕截图并向其添加注释。. 本文包括分类为的键盘快捷方式列表:
Apply data validation to cells - Microsoft Support
Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.
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
配置 Windows Hello - Microsoft 支持
Windows Hello 是登录到 Windows 设备的一种更个性化、更安全的方式。 在 Windows Hello 中,你可以使用面部识别、指纹或 PIN 登录,而不是使用密码。
Open your entire favorites bar in Microsoft Edge
Choose Open all, or Open all in new window, or Open all in new InPrivate window.
Troubleshooting verification code issues - Microsoft Support
That verification method isn’t working right now: Sometimes the block may be tied to the verification method you are using.Try using another verification method connected to your account. For example, if you are using SMS to verify yourself and are hitting a block, try using an alternate email that is connected to the account to receive your authorization code.
Applies To: Microsoft account dashboard
Set up email in Outlook - Microsoft Support
In the Auto Account Wizard, enter your name, email address, and password.
Word for Windows training - Microsoft Support
Learn how to use Word in Windows with training guides, articles, and videos from Microsoft Support.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Office for business
Change the size of text in Windows - Microsoft Support
Here's how to change the size of text, images, and apps in Windows. To change your display in Windows, select Start > Settings > Accessibility > Text size.To make only the text on your screen larger, adjust the slider next to Text size.To make everything larger, including images and apps, select Display , and then choose an option from the drop-down menu next to Scale.