From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using IFS for multiple conditions

Using IFS for multiple conditions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using IFS for multiple conditions

“

- When you're working with nested ifs, you might want to consider a new Excel function called ifs, i, f, s. On the formulas tab in the ribbon, if you click the icon for Logical, you'll see IF in the description, checks whether a condition is met, returns one value of true and another value of false. That doesn't suggest the capability of nesting functions. But when you are nesting functions, you might want to consider using the IFS function. Checks whether one or more conditions are met and returns a value corresponding to the first true condition. Now, in this worksheet here, we've got a series of job ratings in column H and a Bonus is going to be applied using the following rules. If your job rating is four or five, you'll get a bonus of $3,000. If it's a three, you'll get a bonus of $900, if it's a two, a bonus of only $99, and if it's a one you get nothing. So, in cell I2 right here, is the IF function used in a nested form. Now the more nesting you do, the more difficult it…

Contents