Category: Calc Basics

This guide explains how you can check for multiple conditions in Calc using IFS function.

Generic Formula

=IFS(test1, result1, [test2, result2],...)

test1: First logical test

result1: result when test1 is true.

test2, result2 [optional] – second test value pair.

Explanation of IFS Function

When you need to check for multiple conditions in a single Calc cell, you should use the IFS function. For example, we have a cell having marks and we have to determine the grade for it based on a certain range of marks as below.

You can find out the grade of any marks based on a series of conditions. For example, if your mark is 55, you can try out the below formula to find out the grade.

=IFS(E5<40,"D",E5<60,"C",E5<80,"B",E5>=80,"A")

Similarly, you can change the above formula to find out marks by changing guideline grades.

Notes on IFS Function

• There is no way to set a default value in IFS if all the conditions are either TRUE or FALSE. In those cases, keep the last condition test as TRUE or FALSE hard-coded and return a value.

• If all the conditions are FALSE, then IFS returns #N/A error.