8 hours 33 minutes
in this. Listen, I'm going to talk about information functions and why are they important for advanced or intermediate use of excel
Now? Information functions are those that people almost never use in worksheets alone. So their use is primarily intended
to work with look of functions
and to work a CZ, some kindof information giver when you're making macros and doing work it automation.
So first of these is cell
and sell returns requested information in for type over reference cell or or group of cells.
And it's ah,
it's very complex to type because you have to know about
what are you looking at
looking for? And when you look at this info type, it's
explanation is nothing. So you have to click on help function, helping dysfunction and get the
full explanation. And I'll just give you the hint because it makes absolutely no sense for me to explain all off in for types you can request on a cell
so it can be addressed, which gives you the
coordinates. It can be called, which means which column is it? It can be color. It could be contents, which basically gives you what's in the cell.
It can be file name, so you can see the full path off the file in which this cell is the format, which is very important there. There's parenthesis is which shows you if there are parenthesis. Is in the
the cell, used or not
prefix protective. It's protected type of cell with a bit of cell in a calm, so
you can expect the all kinds of information. Sometimes they can be very important when you're writing macros. So, for example, if you pick format
as an infant type,
this is what you can get his, ah, return from the function.
So Gee's for example, General, um, if you get the answer or return like comma to it means it's formatted. There's a number with two decimal points
and so on and so on. I'm not going to explain every one of them because there's quite a few. Uh, what you can do is always go into into help, and if you need to use this sells, you can
But what can happen with it?
So just to give you an example of cell function,
uh, so, uh,
this is Ah,
this is, for example, you type so
and then you look for
this one here,
and you get that too.
And here you will get general for mating. Although this is formative is text because it's just general for mating, it won't return difference between general former thing and formative is text,
and, uh, and yes, that's pretty much it. So you have to
looking these things,
trials to see how it behaves before you can actually use it.
I'm just mentioning it because sometimes it can be very, very useful.
the other function we're talking here about information function is info,
and it returns information about operating and Myron. Now, you might think, Why would I need that in excel sheet? And, uh, the reason is, for example, if you're writing a macro
at the beginning of it,
you want to check
um, which version of accelerator using
because if you're using some function that they're not available in previous versions of Excel or in the current versions of Excel that are not the one you have intended, For example, we're talking here
about off off his 2019 and excel within that office package.
And if you're using office 365 Some off. The functions cannot be used because they or some of the parameters, for example, for cell function cannot be used in our frustrations expiry. You want get the answer. So if you know that you're using something that's specific to this version off
Excel that you
can get info and then release
and you get ah,
answer 16.0, which is this Release off Excel.
Also, this will give you all his version.
This will give you the system so it will answer to you. Is if this is a window system or max system.
This isn't the number off
worksheets in this file. And, for example, this is information on recalculation mode off this worksheet. So is it automatic or manual? This one is automatic, of course. So,
uh, the other
the effects can be the city directory can be origin, which is something that is there mainly for compatibility with the lotus 12 tree. Anybody knows what is 1 to 3 was one of the first spreadsheets offers and so on, so on. So this is
this is all about info.
If you actually need these things, you can also study them in detail.
I'm a pressing on the help
link in the in the explanation syntax window off the dysfunction.
next group off functions which we're going to talk about our is functions and their 12 these franks is black. Is there is there is error is even Its formula is logical, is not text is number is odd Israel and is text and they're quite self explanatory. So
they just returned through a false
and for example, if you reference to a selling, want to check if it is text
If it is text you get true. If it's something else, you get false. It also is Izod will give you the truth. It's old number and false if it's everything else, including decimal number.
So examples off his functions
you can have here. So, for example, is blank
cell that has something in it will give you falls.
But if you have really blank cell, it will give you true.
is there we'll give you
true because we have division by zero here. The only difference between ease air now and his hair is that if the
air is an A,
it will give you a different answer for dysfunction,
then this function because this one will return
true for any kind of error. And this one real return falls. If it's an a error
Ah, then we have is even so 25 years old numbers. So it's false.
This is his formula. So it checks if you have formula in it and you have, so it will give you true.
And this one is formula and gives you false because we have just the constant here. So these air
And finally, in this listen
Ah, I'm going to talk about end
and then is very interesting function between converts known number two, number dates, the serial numbers through to one and pretty much everything else to false. So let's do some check up on it.
we have, ah,
this number that is formative is next,
and it will convert it to actual number.
Ah, but if we type here a B C,
it will give a zero because it's ah,
it's everything else.
So if it's a date, it will give us the serial number of a date.
If it's true, it will give us one If it's false, it will give us zero. And if it's text, it's also going to give a zero.
So this is how function and works.
it can have again use, especially in the writing. Mac Rose
I don't see much use of it in real world.
And that concludes this lesson. Thank you for your attention. In the next lesson, we're going to be talking about look up functions.