Share via

Function IF

Anonymous
2025-06-05T10:35:38+00:00

Hi, does a function similar to function IF but with multple choices exist?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-06-05T10:44:25+00:00

    In Excel 2019 and later, you can use the IFS function:

    =IFS(condition_1, value_1, condition_2, value_2, ...)

    And also the SWITCH function:

    =SWITCH(expression, value_1, result_1, value_2, result_2, ..., default_result)

    0 comments