Welcome! Lets start your excel journey..

Welcome! Register Now to Unlock Exclusive Excel Tutorials

Get Started
  • Exclusive Playlists
  • Downloadable Videos
  • No Ads!
  • Exclusive Templates

IFS Function in Excel

Admin
Duration: 8:12
Submitted: 2 weeks ago
Views: 32

Comments (0)

Link to this video:

Description: IFS Function is one of the most popular or most used function in excel which returns values on the basis of multiple conditions. This function is very identical to IF function as we know IF is limited by one condition whereas IFS can perform multiple conditions as we have described in the above video. In above videom we have described each and everything with examples which you can browse by following the table of content.

Syntax for the IFS function is:

=IFS([Something is True1, Value if True1,Something is True2,Value if True2,Something is True3,Value if True3)

Table of Content;
00:00 Introduction
01:10 IFS vs IF Function
04:01 IFS Function In Excel Ex.1
06:10 IFS Function In Excel Ex.2
07:38 Conclusion