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

Restart your PC and the wireless display or adapter. To remove the device, select Start > Settings > Devices > Bluetooth & other devices. Under Wireless displays & docks, select the wireless display or adapter, then select Remove device > Yes . Try reconnecting. Open Bluetooth & other devices settings. Get tips on how to fix connection issues ...

Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile. Get Microsoft account help. Manage your personal account from a single dashboard, including payment information, purchases, subscriptions, and more. Go to your dashboard.

Select Settings > Mail > Junk email. Under Safe senders, enter the email address or domain you want to add, and select Add. Select Save. Tips: To edit or remove email addresses or domains from the blocked senders or safe senders list, select the item in the list and then select or . To empty your Junk Email folder, select Junk Email in the left ...

Office 2021 is sold as a one-time purchase, which means you pay a single, up-front cost to get Microsoft 365 apps for one computer. One-time purchases are available for both PCs and Macs. However, there are no upgrade options, which means if you plan to upgrade to the next major release, you'll have to buy it at full price.

The phone number provided may have already been used on multiple Microsoft Rewards accounts: There is a limitation on the number of accounts (maximum of 6 accounts per household) that can be associated with one phone number. Please provide a different phone number to be able to redeem your Microsoft Rewards points.

Repair a profile in Outlook 2016. In Outlook 2016, choose File. Choose Account Settings > Account Settings. On the Email tab, choose your account (profile), and then choose Repair. Note: The Repair option isn't available if you're using Outlook 2016 to connect to an Exchange account. Follow the prompts in the wizard, and when you’re done ...

With Word for the web running in your web browser, you can: Create documents to add and format text, images, and page layouts.

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.

For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to. Under Properties, look for your IP address listed next to IPv4 address. Open Wi-Fi setting.