8 hours 33 minutes
okay, in this worksheet, we're having simple transformation
off just size to us size of shirt.
So let's, uh let's go and look at the macro that we
have made for this occasion.
And here it this. So we're now first at the beginnings saying that
number is active Cell Well, you so active cell is the cell. That is
we were selecting now at the
and we're saying just for the sake off less typing.
number is this So
then we start with if structure and we say if number is less and equal of 34 which is
the measurement for
opera, Well, you
be three. Well, you is going to be string called X s containing access
else, So it's not
less or equal to 34 so it's higher.
Then we check if it's less or equal than 36.
And if it is, then it goes into category of size s
and so on. For 38 we go into category of em for less than 40. It's l. If it's less than 42 it's excel. And if it's less than 44 it's double x l
And if none of that is the case,
we get the message Books just size out of range. Check big and tall sizes. So this is these are standard sizes. We have the bigger now because we have six ifs. You see, we said if then else and then we started with next if
then else if then else, anything else
we had six.
Let's say levels off. If,
we have to close it with six end ifs
Now what we can do
we can visually
So we have one space here extra
and then we can
put. And if so, it closes.
It's appropriate level.
And this way
that we have closed everything.
So this and if is at the same
level as if
now it's easier to
see how many of them we need.
We're closing the sub and sub.
We can save this now
let's just check
It's control shift s
Let's just size is 41.5
and we quicken. You have to select this cell control shift. This
and it gets Excel
or 21.4. Sorry.
And if we would put here 49
and click on control shift
We get just size out the French trick. Begin toll sizes
and that's it. Now you see here we got the leftover XXL from the last one, so we have to correct this macro.
So let's go to shirt size
at it. And at the beginning,
Don't. Well, you
so that we make sure the beginning that the well, who is
So if something is left from the previous calculation, it will be arranged. Arranged a racist story.
So let's close this.
And let's, uh,
pris now again, Control, shift this
and it raises the previous result, and we get the correct message here. So this is how dysfunction works.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand