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

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.

Turn off OneDrive in Windows. Windows 10. If you don't want to use OneDrive, the easiest solution is to unlink it. Follow the steps in Turn off, disable, or uninstall OneDrive, for how to unlink, hide, and uninstall OneDrive from your PC.

The transcribe feature converts speech to a text transcript with each speaker individually separated. After your conversation, interview, or meeting, you can revisit parts of the recording by playing back the timestamped audio and edit the transcription to make corrections. You can save the full transcript as a Word document or insert snippets ...

Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support. Find the information you need to import to or exporting from Outlook, whether you're using Office 365, Outlook 2016, or a Mac.

In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.

If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history. On the Order history page, find your order and then look under Status. Open Rewards dashboard. You can also track your order in the confirmation email that was sent to ...

Click on a photo to show the buttons at the top, including Zoom, Delete, Rotate, Edit & Create, Share, and Print. Press and hold (or right-click) for more commands, such as File info, Save as, Copy, and Set as. Open the Photos app from the button below. Open the Photos app. The Photos app in Windows 10 does the same things as Windows Photo ...

You can choose your desktop background and change it at any time. Select Start > Settings > Personalization > Background. In the list next to Personalize your background, select Picture, Solid color, Slideshow, or Windows Spotlight (to see a new image from around the world every day). Note: If you can't select the Windows Spotlight option, your ...

When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.