Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

Keeping leading zeros and large numbers in Excel. Use a custom format to keep the leading zeros. If you want to resolve the issue just within the workbook because it's not used by other programs as a data source, you can use a custom or a special format to keep the leading zeros.

Learn how to check your PC's storage capacity and manage it effectively with Microsoft Support's guidance.

If your account has been hacked, use our sign-in helper tool below to help guide you to the right solutions. The tool will ask for your email address or phone number, and either show appropriate self-help, or offer the chance to talk to an agent.

Safe senders and recipients. Safe senders are people and domains you always want to receive email messages from. Safe recipients are recipients that you don't want to block, usually groups that you’re a member of.

To add text, like a title, in an arbitrary position close to or on top of your SmartArt graphic, on the Insert tab, in the Text group, click Text Box to insert a text box. If you want only the text in your text box to appear, right-click your text box, click Format Shape or Format Text Box, and then set the text box to have no background color and no border.

Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:

Edit photos and videos. Whether you like to apply changes that affect your photo's quality, feel, and look—or you want to add information on top of your photos, the Photos app offers you comprehensive features to transform your photos and videos looking their best.

List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.