/

Check Multiple Conditions Using IFS Function in LibreOffice Calc

4312 views
2

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.


Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.


Join our Telegram channel and stay informed on the move.

Related


arindam

Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials and no BS. Follow us using social channels or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Ward

Hi, I am trying to create a statement with multiple conditions such as
IF F4=approved, {change bacground color to yellow} IF F4=denied, {change background color to red} IF F4 = Paid, {change background color to green}

How can this be accomplished?
Thanks in advance

2
0
Would love your thoughts, please comment.x