AND function - Microsoft Support
The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE.. One common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
What is OneDrive? (work or school) - Microsoft Support
Training: With OneDrive, you can securely store your pictures and files, share and collaborate with others, and get to your files from anywhere - on your computer, laptop, tablet, or phone.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Schedule a meeting in Microsoft Teams - Microsoft Support
Add a dial-in number Include a dial-in number and conference ID so that participants can call in to the Teams meeting. If you schedule the meeting from Outlook, the dial-in number and conference ID automatically appear in the scheduled meeting invite.
Applies To: Microsoft Teams
Microsoft Defender update for Windows operating system installation ...
Important: The National Public Data breach exposed personal information, including names, addresses, and social security numbers.Learn how to protect yourself and how Microsoft Defender is helping to prevent fraud. See: National Public Data breach: What you need to know.
Show or hide the ribbon in Office - Microsoft Support
Choose an option for the ribbon: Show Tabs and Commands keeps all the tabs and commands on the ribbon visible all the time.. Show tabs shows only the ribbon tabs, so you see more of your document, and you can still quickly switch among the tabs.. Auto-Hide ribbon hides the ribbon for the best view of your document, and only shows the ribbon when you select the ellipsis (...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel 2024, Word 2024, Outlook 2024, PowerPoint 2024, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016
FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
How to get service or repair for Surface - Microsoft Support
If your device isn't listed, select Don't see your device? to register it, then follow the instructions to get service. Through this process, you’ll find out if your Surface is in or out of warranty and how much it’ll cost, if applicable. Depending on the product, the service offered may be a repair or a refurbished replacement.
Show or hide the Recycle Bin - Microsoft Support
Notes: To get to desktop icon settings in Windows 8.1, swipe in from the right edge of the screen, then select Search.Type desktop icons in the search box, and then select Show or hide common icons on the desktop.
Join a meeting without an account in Microsoft Teams
If you don't have an account, follow these steps to join. If you're having trouble joining a Teams meeting, try I can't join a Teams meeting . Note: For some meetings, admin settings prevent people who are not signed in from joining the meeting.
Applies To: Microsoft Teams
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones