The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. We will get into all that in addition to some examples, tips, and tricks in this video.

My name is Tony and I have a degree in architecture and business administration. Excel is a powerful tool so don’t get discouraged. I’ve spent numerous hours, days, weeks working on my spreadsheets and years learning what I know. My hope is that my tutorials will be a quick way for you to learn what I know in a more condensed timeline.

The IFS function is a must know essential tool that can be used in numerous applications and workflows. See my courses page for advanced uses of this function in combination with other functions or the related videos section for similar functions.