0:00
hello and welcome to tutorial's point
0:02
today we are going to learn about the
0:04
ifs function in Excel I will show you
0:07
how ifs function works with a practical
0:10
example and compare it with the
0:11
traditional IF function so you can see
0:14
the benefits of using ifs function for
0:18
conditions also the link to download
0:21
this Excel practice sheet is in the
0:23
description below so without wasting
0:25
time let's get started so here we have a
0:28
data set of sales person their sales
0:31
unit sold customer rating and we want to
0:33
find out the performance category now
0:36
here as you can see we have this sales
0:38
and performance category so for the
0:40
sales greater than $80,000 the
0:42
performance category is outstanding for
0:45
the sales greater than $50,000 it's good
0:48
and for the sales of less than
0:51
$50,000 needs Improvement very simple
0:54
now here first I'm going to show you
0:56
using the IF function and then I will
0:59
show you how to use the fs function to
1:02
achieve the same result so let's start
1:05
with the IF function so here in this
1:06
cell I'm just going to quickly paste the
1:08
IF function and let me just explain I
1:10
have written here the IF function and
1:12
then I have taken this C2 cell which is
1:14
the sales cell so if this sales cell is
1:19
$80,000 then it should Simply Be
1:22
outstanding all right now if this
1:25
condition is not true then I have
1:26
another nested IF function now inside
1:29
this what what is going to happen is if
1:31
the sales is greater than or equal to
1:35
$50,000 uh return good and if this
1:38
condition is not true that means the
1:40
sale is less than $50,000 in that case
1:43
just return needs impovement so I hit on
1:47
enter and as you can see we have the
1:49
outstanding here and I can just drag the
1:51
cursor down something like this and we
1:54
have the results we needed but if you
1:57
look closely at the formula as you can
1:59
see we have a nested if statement here
2:02
now we only have three values here what
2:04
if we had multiple performance
2:05
categories it will be very difficult for
2:07
us to uh you know write the formula for
2:10
nested if right so in that case we are
2:13
going to now use the ifs function to
2:16
make our formula much simpler and easier
2:19
to understand so the ifs function
2:23
basically allows you to test multiple
2:26
conditions without needing to Nest
2:27
multiple if statements it evaluates
2:31
conditions in the order they are
2:32
provided and Returns the corresponding
2:34
value for the first true condition so
2:36
basically the ifs statement makes it
2:39
easier to write and read formulas that
2:41
need to check for several conditions so
2:43
for here in our example I'm going to use
2:45
the fs function so here I'll write
2:48
equals fs and then parenthesis now first
2:51
we have to write The Logical test so
2:54
it's going to be very simple in our case
2:56
we want to check for the sales so I'll
2:57
select this column so this column of
3:00
sales if this column is greater than
3:04
$80,000 in that case what we want is we
3:08
want to have this value of outstanding
3:14
outstanding all right so this is the
3:16
first condition then we have the next
3:19
condition now after this outstanding
3:21
what do we want is The Logical test two
3:24
now in this case I again will select
3:26
this cell and I will say if this C2 sell
3:30
of sales is greater than or equal to
3:37
$50,000 in that case the result should
3:41
be good all right and after this I'm
3:44
going to say if the same sell of sales
3:52
$50,000 something like this in that case
3:56
the value should be needs
4:01
Improvement something like this and let
4:04
me just close the parenthesis so it's
4:06
very simple first we have written the
4:08
ifs formula and then we have the logical
4:10
statement so if this is true return
4:13
outstanding similarly if this is true
4:16
return good and if this is true return
4:19
needs Improvement if I hit enter as you
4:22
can see we have the same result and if I
4:25
drag this down as you can see the job is
4:29
is done but now let's do a quick
4:31
comparison this is the if statement we
4:33
have multiple if statements and if we
4:35
have more categories it'll be difficult
4:37
for anyone to read this formula but at
4:39
the same time if you look at the ifs
4:41
function it is very straightforward you
4:43
have a condition and then the outcome
4:46
condition and then the outcome this is
4:47
the condition and then the outcome so it
4:50
becomes very easy to read and understand
4:53
so this is the fs function in
4:56
Excel so that will be enough for this
4:59
video now along this ifs function there
5:01
is another function called as the switch
5:04
function which can be again used in
5:05
place of nested if functions now I have
5:08
already created a video on switch
5:10
function you can find it in the link uh
5:12
in the description below or you can see
5:14
it on the channel as well also the link
5:17
to download this practice sheet is in
5:20
the description below now make sure to
5:22
like this video share it with your
5:24
friends and I will see you in the next
