IFS

Several conditions.

  • Snippet
  • Conditions and counting
  • 5 blanks to fill

Fill in the blanks

Your text

=IFS(Condition 1, Result 1, Condition 2, Result 2, TRUE, Otherwise)

Orange words are blanks you have not filled yet.

About this template

Several conditions.

Pack
Conditions and counting
Type
Snippet, a short message
Asks for
Condition 1, Result 1, Condition 2, Result 2, Otherwise

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

Template source

The template as written, with its blanks in double braces, such as {{Name}}.

=IFS({{Condition 1}}, {{Result 1}}, {{Condition 2}}, {{Result 2}}, TRUE, {{Otherwise}})

More spreadsheet formulas templates

See all 75 spreadsheet formulas templates