仕組みと動作原理
IFS関数はExcel業務を効率化する代表的な関数です。複数の条件が満たされているかを順次判定し、最初にTRUEとなった条件に対応する値を返します。 複雑な集計や参照処理を簡素化し、データ分析の精度と生産性を飛躍的に高めます。
💡 わかりやすい要約
Checks multiple conditions in order and returns the grade/value matching the first true condition.
"Think of this like a grading machine checking grades in order: IF score is 90+ print A, IF 80+ print B, IF 70+ print C, otherwise print F."
構文.
標準Excel表記法=IFS(論理式1, 真の場合1, [論理式2, 真の場合2], ...)引数一覧.
この関数で指定できるすべての引数について詳しく解説します。
The first condition to test.
指定例:C2>=90The value returned if the first condition is TRUE.
指定例:"A"The second condition to test.
指定例:C2>=80The value returned if the second condition is TRUE.
指定例:"B"Use TRUE to create a catch-all default condition.
指定例:TRUEThe default value if no prior conditions are met.
指定例:"F"具体的な計算例
ステップ別の実務シナリオScore Grade Labeler
Assign grades A, B, C, or F based on scores.
| Name | Subject | Score | Grade | Scale |
|---|---|---|---|---|
| Bella | Science | 92 | — | 90+ = A |
| Caleb | Science | 81 | — | 80+ = B |
| Dylan | Science | 74 | — | 70+ = C |
=IFS(C2>=90, "A", C2>=80, "B", C2>=70, "C", TRUE, "F")Evaluates IFS over the sample table cells, placing the verified output in cell D2:D6.
数式ジェネレーター
ウィザードを開く引数を入力するだけで、シートにそのまま貼り付けて使える数式を作成できます。
=IFS()出力される値の特性
Returns "Calculated output" based on sample evaluation criteria and active cell references.
実務上のベストプラクティス
- Always add a final condition of TRUE as a catch-all default at the end of the argument list (e.g. TRUE, "Other") so the formula doesn't return #N/A if no conditions match.
よくあるミスと注意点
- IFS evaluates conditions from left to right. Make sure your conditions are in the correct order (e.g. start with >90, then >80, then >70).
各プラットフォーム対応表
実際のExcelおよびGoogleスプレッドシートの計算エンジン仕様に基づいた検証結果です。
In Excel 2016 or older, nest standard IF formulas: =IF(c1, v1, IF(c2, v2, v3)).
Introduced in Excel 2019 and Excel 365. Supported in Excel 2019, 2021, and 365.
100% compatible with Google Sheets with identical condition/value syntax pairs.
よくある質問と回答
技術解説Can I use IFS across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =IFS(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in IFS?↓
IFS evaluates conditions from left to right. Make sure your conditions are in the correct order (e.g. start with >90, then >80, then >70).
Does IFS work identically in Google Sheets?↓
Yes, IFS is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.