Technical Details. Here are overviews of how to structure AND, OR and NOT functions individually. When you combine each one of them with an IF statement, they read like this: AND – =IF (AND (Something is True, Something else is True), Value if True, Value if False)

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. 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.

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

Find your error code. If you’ve received an error code, we have solutions that can help you to resolve your issue. Just browse for your code in the list below. For additional PC help, go to: Troubleshoot issues with the Xbox app for Windows. For additional console help, go to: Troubleshoot game issues on Xbox. Error codes. Collapse all. Xbox 360.

You can link your social media account in one of two ways: Use the Xbox mobile app to scan the QR code. Select the Link option which will launch the Microsoft Edge app on Xbox. You can choose to link your Discord, Reddit, Steam, Twitch, or other social media account.

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

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.

The Microsoft Authenticator app helps you sign into your accounts when you're using two-step verification.

How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

If you pre-ordered a game and want to cancel, you can do so up to 10 days before the game launches at: Order history. After this time, you may be billed, and you’ll need to request a refund to cancel your order. For more info about digital game pre-orders, see: Pre-order Xbox digital games in the Microsoft Store.