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

If you experience a black or blank screen on your Windows device, try the following: To wake the screen, use one of the following keyboard shortcuts: Windows logo key + P to choose a presentation or projection display mode. Ctrl + Alt + Del to display security options. For a black screen, use the following keyboard shortcut: Windows logo key ...

To clear your TPM, follow these steps: Go to Start > Settings > Update & Security > Windows Security > Device security . Under Security processor, select Security processor details. Select Security processor troubleshooting, and then under Clear TPM, select Clear TPM. You'll need to restart your device to complete the process.

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.

View hidden files and folders in Windows. Windows 11 Windows 10. Windows 11 Windows 10. Open File Explorer from the taskbar. Select View > Show > Hidden items. Learn how to show hidden files, folders, and drives in Windows.

If the AutoRecover option is turned on, you can automatically save versions of your file while you’re working on it. How you recover something depends on when you saved it. If you’ve saved the file. Open the file you were working on.

Once you remove your password from your account, you will need to sign in using a passwordless method like the Microsoft Authenticator app, Outlook for Android, Windows Hello, physical security keys, or SMS codes. Note: We will start to offer sign-in approval notifications in the Outlook for Android app from January 2024.

New features in the Photos app on Windows 10. Memories: Relive your memories and create new ones via OneDrive. Filmstrip: The new filmstrip lets you easily find all photos and videos in one window and jump to other photos without leaving the filmstrip. Multi-view: Compare multiple photos and videos side by side in the same window with multi ...

Get in touch with Microsoft Support for assistance with Microsoft products and services.

Tap the Windows Start button and type BitLocker. Select the Manage BitLocker Control Panel app from the list of search results. In the BitLocker app select Back up your recovery key. Select where you want the key backed up. Save to your Microsoft Account - This will save the key in the Recovery Keys library of your Microsoft Account where you ...