Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Use the SUM function to sum numbers in a range - Microsoft Support
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
SUM function - Microsoft Support
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM (A2:A10) Adds the values in cells A2:10. =SUM (A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Screen mirroring and projecting to your PC or wireless display
If you’re working on a Windows PC and want the apps and content from another device to show on your PC screen, you’ll want to consider mirroring that device‘s screen or projecting it to your PC. Note that you’ll need a device that supports Miracast. Here’s how to mirror another screen or project to your PC. Windows 11 Windows 10.
SharePoint にサインインする - Microsoft サポート
SharePoint にサインインする. SharePointは、次のように、Web ブラウザーを介して接続するブラウザー ベースのアプリです。. [office.com] に移動し、職場または学校アカウントにサインインします。. ウィンドウの左上隅で、 [ すべての アプリ] > > アプリ起動ツール ...
Applies To:
SharePoint in Microsoft 365
COUNTIF function - Microsoft Support
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
OneDrive を開き、ファイルをアップロードする - Microsoft サポート
OneDrive を開き、ファイルをアップロードする. OneDrive には、300種類のファイルを保存できます。. セキュリティで保護されており、ブラウザー、モバイルアプリ、Mac、Pc で利用できます。. Office ドキュメントでは、Office を使っているかどうかに関係なく、他 ...
Applies To:
OneDrive (work or school)
Fix sound or audio problems in Windows - Microsoft Support
If the Get Help app is unable to resolve your sound or audio issue, try the possible solutions listed: Windows 11 Windows 10. 1. Check your speaker output. 2. Run the audio troubleshooter. 3. Verify that all Windows Updates are installed. 4. Check your cables, plugs, jacks, volume, speaker, and headphone connections. 5. Check sound settings. 6.
ファイル要求を作成する - Microsoft サポート
OneDriveまたは Sharepoint のファイル要求機能を使用すると、送信するリンクを使用して他のユーザーがファイルをアップロードできるフォルダーを選択できます。. ファイルを要求するPeopleは、ファイルのみをアップロードできます。. フォルダーの内容を表示 ...
Applies To:
OneDrive for Business, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows