Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Merge tables with VLOOKUP in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get last row in text data in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Analysis Examples

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to Create Gantt Chart in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How To Compare Two Lists in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain
  • Excel Data validation no punctuation
  • Excel Data validation unique values only

How to use IFS function in Excel

by

Use the IFS function in Excel 2016 when you have multiple conditions to meet. The IFS function returns a value corresponding to the first TRUE condition.

Note: if you don’t have Excel 2016, you can nest the IF function.

1a. If the value in cell A1 equals 1, the IFS function returns Bad.

1b. If the value in cell A1 equals 2, the IFS function returns Good.

Worked Example:   IFS function: Description, Usage, Syntax, Examples and Explanation

1c. If the value in cell A1 equals 3, the IFS function returns Excellent.

1d. If the value in cell A1 equals another value, the IFS function returns No Valid Score.

Note: instead of TRUE, you can also use 1=1 or something else that is always TRUE.

Here’s another example.

2a. If the value in cell A1 is less than 60, the IFS function returns F.

Worked Example:   IFS function: Description, Usage, Syntax, Examples and Explanation

2b. If the value in cell A1 is greater than or equal to 60 and less than 70, the IFS function returns D.

2c. If the value in cell A1 is greater than or equal to 70 and less than 80, the IFS function returns C.

2d. If the value in cell A1 is greater than or equal to 80 and less than 90, the IFS function returns B.

Worked Example:   IFS function: Description, Usage, Syntax, Examples and Explanation

2e. If the value in cell A1 is greater than or equal to 90, the IFS function returns A.

Note: to slightly change the boundaries, you might want to use “<=” instead of “<” in your own function.

Post navigation

Previous Post:

How to Check If A Cell Contains Specific Text in Excel

Next Post:

How to create Roll the Dice in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • SUBSTITUTE function vs REPLACE function in Excel
  • Complete List of Excel Text Functions References and Examples
  • How to Capitalize first letter in a sentence in Excel
  • Convert Text to Numbers in Excel
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • Next biweekly payday from date in Excel
  • Pad week numbers with zeros in Excel
  • Get date from day number in Excel
  • Convert decimal minutes to Excel time
  • How to show last updated date stamp in Excel
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
  • How to calculate Net Present Value (NPV) in Excel
  • How to calculate compound interest in Excel
  • How to Calculate Tax Rates in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles