this tutorial we will see how we can

apply multiple if conditions where we

can consider more than one condition in

nested head so I have some data here on

this sheet where we can see we have

employee ID employee name and surly so I

need to figure out that category of

cellie is what so in this case we have

four conditions and for each condition I

have given a name so by looking at the

numbers in certainly I have put one

condition like if Shelley is less than

or equal to 2010 we need low and if cell

is more than 2000 and less than 5000

then value should be medium if it is

more than 5000 and less than or equal to

10,000 let me broaden this then it

should be high and if it is more than

with 10000 then value should be

top-level these values I want to be

presented here with the help of nested

with function so let's see how we can

apply an STD function equal to if open

parentheses then I will select the value

is less than or equal to 2000 then it

should be low and a now I need two

conditions like more than 2000 and less

than or equal to 5000 so I will write

here as and open paranthesis then I will

select this cell again where I have

value and my first condition is if this

value is greater than 2000 and same cell

as less than or equal to 5,000 so this

is the second condition where we have

two conditions like more than 2,000 and

less than or equal to 5,000 then I will

close bracket

I want value to be medium and a now I

will select this L again where we have

value which is C 3 before this let me

write and because we have again two

conditions if C 3 as greater than 5,000

and C 3 is less than 4 equal to 10000 so

these are two conditions which we have

to get the value as high then I want

value as I else

both condition we don't have more than

poor condition

so last condition is a c c 3 has more

than 10,000 so now we will not write

anything

we will be straight forward right else

top level now will close first

parenthesis we can see color - purple

second parenthesis color as green and

parenthesis parenthesis color is black

so we will stop here I will press ENTER

and now we can see the result I will

drag the formula down to see the various

wizard this is how we can write if

condition or if formula with multiple

conditions you can make a note of this

formula

and we can use this from lies per our

requirement thanks for watching this

video