I'm going to talk about the solver
that's available to you in Excel on the
data tab you go at the end here and it's
the solver so what I've got here is I
have a basic mark breakdown so we have
the the three marks that makes up make
up the final marks of for the student
he's already achieved only 75% on his
assignments and he has yet to write his
midterm in his final but he needs to get
90% for him to get honors in this course
so what he's going to do we're going to
do is we're going to figure out what he
needs to do to get this we are going to
go click the solver button here and so
we've already selected the total that
the end of this the end calculation here
and so what we have now we would like to
change this value to about it gives you
two maximum to minimum or to a value of
so I'm going to select to a value of and
I know what I want 90 okay now next is
it's asking you by changing which
variables so we click on the red blue
arrow here and we select the midterm and
the final mark here and now we click the
red arrow again okay now we need to add
some constraints here the the highest
possible mark that he could get on
either of these is 100% so let's add add
some constraints here and so what we're
going to do is we're going to select the
value or the cell where the value goes
and as you can see it is it it's less
than or equal to now you have the term
the drop-down list you have other
options there of what it can possibly be
but this is what we need so the most it
could possibly be is 100 and then we're
going to click Add to add it to
constraints and then we're going to
click the other cell here the final and
the same
most it could possibly be is owing on
100 okay and so now we say okay and
they're in there it's all it's all ready
for you so now let's click on the solve
button here so let's drag this away so
for him for this student to get 90 on
his final as a final mark he needs to
get 91 and 100 they put the final value
to the highest because the final is
worth 40% so it's more important for him
to get the higher mark on the final and
ninety one point six is all he needs him
the midterm so we have options here with
the dialog buttons you button you can
keep this the solved solution restore
the original values okay so we're going
to keep this but now what we would like
to do is we would like to run a report
so let's select answers and say okay and
now we have our answer report here and
as you can see it has broken down all
the information that is determined for
you so this is how you use the solver by
the way the solver is an add-on if you
don't have this add-on what you need to
go is file on the menu bar and then you
go to options and then you go to add-ons
and then you can nut as you can see it's
right right down here just click on that
to add it into your options so that's
how you use the solver in the excel
sheet please subscribe