If you can't find an app or program, try the tips in See all your apps in Windows 10 and Program is not listed in add/remove programs after installation. If you get an error message when you're uninstalling, try the Program Install and Uninstall Troubleshooter.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

If you run into problems trying to connect to a Bluetooth device, here are some troubleshooting steps to try. Note: For general info about how to connect a Bluetooth device to your PC, see Pair a Bluetooth device in Windows.

Cast to a display from a Windows PC. You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.

Possible causes. Make sure your PC, the external display, and the cable all support DisplayPort or MHL alternate modes. Make sure the device or dongle is connected directly to your PC. Make sure the device or dongle is connected to the USB-C port on your PC that supports the correct Alternate Mode.

Help with giving digital games as gifts. Note that if you purchased content that isn’t working, check the Xbox status page for any issues that may prevent you from playing, and try troubleshooting the problem before making a request for a refund: Xbox status. Troubleshoot game issues on Xbox.

AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) The AVERAGEIFS function syntax has the following arguments: Average_range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers. Criteria_range1, criteria_range2, ….

Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar. If the app is already open on the desktop, press and hold (or right click) the app's taskbar icon, and then select Pin to taskbar.

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

It is periodically updated based on customer feedback to help you make the most of your Windows PC. How to open PC Health Check. In Windows, use Search on the taskbar to search for “PC Health Check,” then select it from the list of results.