The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1 ...

Select Security info in the left menu or by using the link in the Security info pane. If you have already registered, you'll be prompted for two-factor verification. Then, select Add method in the Security info pane. On the Add a method page, select Authenticator app from the list, and then select Add. On the Start by getting the app page ...

Click or tap anywhere in the page you want to delete, press Option+⌘+G. In the Enter page number box, type \page. Press Enter on your keyboard, and then select Close. Verify that a page of content is selected, and then press Delete on your keyboard. To remove blank pages in the middle or at the end of your document, see Delete a blank page.

Select Start > Settings > System > Activation . Select Change product key, and then enter the 25-character product key. Open Activation settings. If you've made a major change to your device's hardware, such as a motherboard replacement, run the Windows Activation troubleshooter located on the activation settings page.

Upgrade to Windows 10 Pro. Windows 10. Windows 10 Pro offers more advanced security and business networking features, including: BitLocker Drive Encryption. Remote Desktop. The ability to join a domain or Azure Active Directory. If you're running Windows 10 Home, select Get Windows 10 Pro to upgrade your device.

Open Device Manager. In the search box on the taskbar, type device manager, then select Device Manager from the menu.

To change how icons and notifications appear. Press and hold or right-click any empty space on the taskbar and select Taskbar settings. Under Taskbar corner icons: Select On for any icons you want to see on the taskbar. Select Off for any icons you don’t want to see on the taskbar.

Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

Check that the page shows the correct Microsoft account, and then click Next. Read the list and click the checkboxes to acknowledge you’ve read each item. Choose to have the re-open window set to 30 or 60 days. In the Select a reason drop-down list, choose an explanation for why you're closing the account. Click Mark account for closure.

In some editions of Windows 10, it's included as an optional feature that you can enable. To do that, select the Start button, then select Settings > Apps > Apps & features > Manage optional features > Add a feature > Windows Media Player, and select Install. Enable Windows Media Player. DVD playback isn't included.