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.

View previous versions of a file. If your file is stored in OneDrive or SharePoint in Microsoft 365, you can go back to a previous version of file.

We would like to show you a description here but the site won’t allow us.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

In an app, press Ctrl + V to use the default paste, which adds a link with the title of the page as the link text. If you're pasting into an app or website in Microsoft Edge, you can also right-click, select Paste as on the context menu, and then select Link (Default) from the sub-menu.

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!

Examples. See various examples in the figure below. Look closely at the use of the TEXT function in the second example in the figure. When you join a number to a string of text by using the concatenation operator, use the TEXT function to control the way the number is shown. The formula uses the underlying value from the referenced cell (.4 in this example) — not the formatted value you see ...

There are two ways to get Office on your iPhone: Tap the button below to install the new Office app for iOS that combines Word, Excel, and PowerPoint into a single app, which introduces new mobile-centric features to view, edit, and share files without the need to switch between multiple apps.

Dictation lets you use speech-to-text to author content in Microsoft 365 with a microphone and reliable internet connection. It's a quick and easy way to get your thoughts out, create drafts or outlines, and capture notes.

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 the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.