IFS Function : How To Use IFS Function In Microsoft Excel and Google Sheets With Examples

IFS Formula In Microsoft Excel With Example

IFS Function is evaluates multiple conditions and returns the result corresponding to the first true argument. It can be used in a place of nested If formula/statement which is actually easy and perform without any parameters/syntax error.

Table of content:

1.The syntax of IFS Formula is as below

2. IFS Formula Example In Excel and Google Sheets

The syntax of IFS Formula is as below:

=IFS(Logical test1,value if true1, [Logical test2, value if true2], [Logical test3, value if true3], [Logical test4, value if true4].....................), 

Where,

• Logical test1(mandatory): Condition that evaluates to true or false
• Value if true1: The value to be return if condition 1 evaluates to true
• Logical test2, test3, test4: Conditions to be evaluated (optional)
• Value if true2, true3, true4: Returns the value as result the first condition evaluates to true (optional)

Note: Excel's IFS function allows up to 127 arguments.

Let's learn with an example. Here i am listing only a single example of IFS formua as it is same in both excel sheets and google sheets so let's save the time and quickly learn it....................

IFS Formula Example In Excel and Google Sheets

(Step by Step Guide)

1.Start typing the formula as =IFS( then condition as showing in the below image.

2. You will get the result/answer as per the conditions met accordingly.

2. As seen in the above image A2 cell contains 95 and that is greater than so it returns and evaluates to A+ grade as per the condition.