## HOW TO USE EXCEL IFS FUNCTION

Introduction IFS comes in the category of logical functions. IFS function can be used for logical comparison of values and to get the first result when the comparison is TRUE and second result when the comparison is FALSE. IFS function can do multiple tests in a single run and is a very good alternative of nested IF function. It is evaluated by putting various logical operators like “=”,”>”,”<” etc. in the formula .IFS function is also used in combination with…