IFS Function in Excel

In this post, you’ll learn about the IFS Function in excel and how you can use it in your Excel spreadsheet.

What is IFS Function in excel?

The Excel IFS function runs multiple tests and returns a value corresponding to the first TRUE result. This function is an alternative to the Nested IF function and it is much easier to use. 

The following steps will explain the work of IFS Function in Excel:

  • First, prepare an excel sheet with the required details in it.
How to use IFS Function in Microsoft Excel Spreadsheet?
  • To check the IFS Function condition use the following formula: = IFS(logical_test1, Value1 [logical_test2, Value2] …, [logical_test n, Value n]) or for better understanding =IFS(B2>60,”D”,B2>70,”C”,B2>80,”B”,B2>=90,”A”).
How to use IFS Function in Microsoft Excel Spreadsheet?

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021