Hello and welcome to our new video
In this video we are going to understand
a formula
with multiple conditions
ok
we have seen this formula in last video
that how to use it
there we have seen some symbols
less than symbol, greater than, less than
equals to, not equals to
but there what we have done
there we have applied only one condition
but here what we are going to do
we are going to apply multiple conditions
first of all open excel
so I open excel from here
and here I have some data
stored here
this data is student's name
and some subjects marks
and here maximum marks
and here some percentage
and grade is given
and result is pass or fail
and here some conditions are there
like if any student's marks
is greater than 80%
then he will be given A grade
if any student's marks is greater than 90%
then he will be given B grade
if any student's marks is greater than 40%
then he will be given C grade
if any student's marks is greater than 33%
then he will be given D grade
otherwise he will be given F grade
and result is fail
so here grades are written
but I delete these grades
and here I apply this formula
with multiple conditions
and show you
that how we can use
this formula
first of all I delete this
from here
I delete this
from here
and here I apply this formula
so first of all
what I have to do
for any formula
I have to apply sign of equals to
so I apply sign of equals to
and after that I apply if condition
now it suggest me
so I double click this
and now it suggest me
to apply logical test
so here I am telling you
that
I have to apply this condition
on J column
like here 85% marks
so I have to apply condition
that if any student's marks is greater than 80%
then he will be given A grade
if any student's marks is greater than 60%
then he will be given B grade
if any student's marks is greater than 40%
then he will be given C grade
and
how we know the name of this cell
first see the column
and then see the row
so from here I know that it is J2
so I write
if J2
greater than equals to
80%
now
it is necessary to apply this percentage
then only he will be able to
distinguish
what we have to do
if J2 greater than
equals to
60%
then
he will be able to distinguish
what we have to do
if J2
greater than
equals to
60%
then
he will be able to distinguish
what we have to do
if J2
is equal to 60%
then
B grade
will be given
if J2
is equal to 60%
then
B grade
after this
we will show the condition
double click
I have written if j2 greater than equals to 40%
ok
40% should be equal to Cgrid
ok
I have put comma again
I have written if
and here I have written
let's make its size smaller
so that it becomes visible
no this is wrong
not k19 because I had clicked there
that's why it came
if j2 greater than equals to 33%
then what should come here
then it should come here
dgrid
ok
otherwise what should come
otherwise
fgrid should come
ok
as we have seen earlier
in this condition
that we have put a condition
and then we have written minor
and then we have written adult
so here I have put 4 conditions
and then the last condition
which is less than 33%
or we can put condition of 33%
otherwise it can pick wrong number
ok
so
we do it safely
here we select if
here if
and in this formula I have written
if j2 is less than
from which
from 33%
then what will come here
here your
fgrid
ok
and after this
what I have to do
after this all the brackets
which I have opened
I have to close all the brackets
so let's count from here
1
2
3
4
sorry from here
1
2
3
4
and 5
so I have 5 brackets
I close these 5 brackets
1
2
3
4
5
ok
and I press enter
see
this grid has come
ok
now what I have to do
I have to drag simple
because
on other cells also
same formula will be applied
so let's do it
I went from here
and I dragged it from here
so you will see
here it is 32%
and what is written here
fail is written here
ok
67%
b
you can check from here
above 60% is b
so here also
59%
c
because between 40% and 60%
what is written
c
ok
and 31%
f
fail
ok
so like this
you can use multiple conditions
with if
I hope
it will be clear to you
if you have any doubt
then you can play this video again
and see
ok
I will meet you in next video
till then
keep practicing