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.

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

Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.

A Desktop Alert is a notification that appears on your desktop when you receive a new email message, a meeting request, or a task request. By default, Desktop Alerts are turned on.

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting two blank cells, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Word 2021 for Windows enables you to create compelling content and includes co-authoring, new stock media from the Office Premium Creative Content collection, and new Draw tab additions such as Point Eraser, Ruler, and Lasso.

On the Home tab, in the Paragraph group, click the arrow next to Bulleted List, and then click Define New Bullet.

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