Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...

If the USB recovery drive doesn’t work on your Surface. If you can’t boot from your USB recovery drive or don’t see the Recover from a drive option, you may need to ensure that the boot-from-USB function in the Surface BIOS is enabled or configure the boot order so the USB drive is the first option. For more info, see Boot Surface from a USB 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

When you add an email account to Outlook, a local copy of your information is stored on your computer. This feature allows you to access your previously downloaded or synchronized email messages, calendar information, contacts, and tasks without an internet connection.

How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!

Take a closer look at the macro . You can learn a little about the Visual Basic programming language by editing a macro. To edit a macro, in the Code group on the Developer tab, click Macros, select the name of the macro, and click Edit.This starts the Visual Basic Editor.

Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.

Training: Watch and learn how to use Word in Windows. Explore Microsoft Word training guides, articles, and how-to videos.

Closing a Microsoft account means you won’t be able to use it to sign in to any Microsoft products or services, including Outlook.com or Hotmail, OneDrive, Xbox, Skype, Office or Microsoft 365, Rewards and Microsoft Certification.