6 hours 3 minutes
okay, In this lesson, I'm going to talk about types of formulas at least those that are most important for
de everyday work.
the formula's again are the main tools Off Excel. This is what makes Excel powerful software,
and what you have as a major, four groups are mathematical formulas, which are the most common ones.
Then you have text formulas, you have logical formulas, and you have look up formulas
and I'm going to go through each one of them in the examples.
So you have seen some Matt formulas
playing this one.
uh, these formulas can included in itself
calculations we dare not
easily obtainable for make basic mathematical. A peerage is plus minus multiplication and division.
So, um, you have when you, for example, when you go to the mat and trigonometry
formulas, you have a whole variety of them and these air functions
and these functions are there because they're here to make your life easier because, for example, you have
logarithms. So if you're using a lottery team off anything
with the base 10 for any kind of calculation mathematical, you can just put it here
and add the whole thing.
I'm not going to go into all of these formulas function. Sorry, because they are, at this point, pretty much irrelevant. Most of these functions, anyway, are used only by people who have very specific need. For example, trigonometry functions
they are there for,
you know, people who who do some calculations, engineering or mathematical. And most of the people simply don't need them.
So let me give you some more examples of formulas. So, for example, we can go with them.
Uh, sorry, uh, like
And then we wanted
and you would get this
to the power of three.
And we get this
for example, if you put here number nine
and we want to calculate the square root. If you remember your math, it will be this
to the power off 0.5 which square? Root and square root of nine history.
So this is an example of mathematical formula.
Now, the next type off formula is string form ur text formula. And the simple thing is,
that you have
first name and last name,
and for some reasons, for some self tour for some application. You want all of these in oneself,
so you would say equals. Which means you're entering formula. Every time you're entering your formula, you have to start it with equal
and then see this
and instead of plus because this is not the number, this is a text. We're going to use the ensign
and we get this, unfortunately, without the space. So if we want to add the space here,
we'll just add
or, ah, text constant, which consists of one
blank one space.
And if we enter Blair Center,
we get my name and first name and last name separated by space.
So this is a simple example of what you can do with text in excel.
There are other functions that work with text there, quite a lot of them.
Ah, and I am going to
talk about just a few off them here because using most of them is, ah
more for some little bit more advanced level of future of excel. I'm just giving you the example what you can do and how to put the strings together.
Okay, so we have
functions as well,
and they also can be used on a very primitive level or very complex level.
if we have ah, logical constant, which can be true
You see how they're automatically placed in all capitals? Because this is how excel
make sure that you understand that this is not a text, that this is a logical variable.
if we want to say,
made me want to see to
to fields and
put them together
we can say this one
plus this one
and this will give us one
so true. Plus falls is equal to ideological or
and it will give us one because true plus false is true and this is represented by one.
Also, if we say this one
multiplied by this one is an equivalent of logical end
so true and falls together
with end operator.
They give zero because true and false,
it can. If it's true and falls, the result is false, which means zero.
So if I put here true
will get here too, because the true is equivalent off. Numerical value of one
and false is equivalent to a numerical value of zero. So true,
Plus true, is equal to one plus one.
multiplied by true is equal to one multiplied by one, which is one.
So this is how you can manipulate logic. And I'm just going to give you one simple, logical function here just to see what you can do
so you can have the function If
and then you can have a logical test, the beach can be, for example, if this cell is smaller than 40.
and then what happens if it's Ah well, you is true. So it's you can just put cell is smaller,
this is it. In case of false, we get nothing. So if you put here 55
we get false.
So this is how the if function, which is a logical function, works.
And we'll get back to, if in the future, more and more because it is a very powerful thing that can help you decide on what to do,
whether the contents of a certain cell or group of cells gives a certain result or not.
let's ah, look att, just the look up formulas or look up functions
and for example, Ah,
let's look a TTE were a simple one.
and the this is index
and its index gives you the value off the cell at the intersection off
cells with dro and
Ah, and, uh,
let's do this.
And let's say airy or a group of cells is this.
And then row number begin. This is two and call number within. This is one
and it gave us his nine. So we selected this
range. Lookit here. A one to be four.
And then we said, Okay, give me the value of the cell
second row, first column. And this is this cell
and use. Look at this and say, why didn't you just pick this cell? Well, it's simple because, for example, we can
instead of firm
just giving Constance here we can hear point
and this cell
and we get the well you, which is something wrong because we're pointing to basically zero and zero. And it cannot be done in that ray.
But we can put here, for example, one
and then it gives us 3 67 So this is
the example off. Look up functions now we're not going to talk a lot about look functions in this
Ah course, But I just giving you the example. What Excel can do with basic look up
and this ends this