hi my name is Justin Conway I'm a

Microsoft Excel expert and I'm going to

show you how to use nested formulas in

Microsoft Excel the reason you would use

the nested formula is because you want

to perform several functions but have

that data all calculated and then input

into one cell so for instance we take a

look at my workbook here this sheet I

have averages and if I wanted to

calculate how the average would be

converted into a actual alphanumeric

score I would need a nested formula to

perform that function and I have one

installed here so you can see I'll break

down the way this formula is laid out

first of all it's called an F function

that you would be using to perform this

particular nest and so it B equals F and

then open parenthesis and let me quickly

explain also if you see all the way at

the end you see multiple end parenthesis

marks this is because the way you

perform a nest is housing the different

bits of parentheses inside the one main

parentheses is the first one this is the

last one and then you have the different

functions in between which are nested

and and they're all closed out with with

their respective parentheses at the end

and it's color-coded so that you can see

this is the last formula in green and

this these parentheses are how straight

in this area okay so what you do is

refer to after your parentheses refer to

the cell that you want to calculate the

value here I want to know if the value

is greater than 89 and if it is I put in

a comma and that will be the value that

comes next and the value I want to

display is an actual capital letter A

and that'll tell me that that score is

actually you know the grade a so then

you want to perform your next function

which is another if

and you want to say if the grade is

greater than 79 then that person should

receive a B so it's the same as the

first function it's simply nested notice

that there is no closed parenthesis over

here it's open parentheses comma another

F function and another open parenthesis

and then once you create all of your

functions going across you close out all

of the functions within parenthesis so

that's basically how to create a nested

formula in Excel my name is Justin

Conway I hope you enjoyed