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.
then we start with if structure and we say if number is less and equal of 34 which is
be three. Well, you is going to be string called X s containing access
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
Let's say levels off. If,
we have to close it with six end ifs
So we have one space here extra
put. And if so, it closes.
It's appropriate level.
that we have closed everything.
So this and if is at the same
see how many of them we need.
We're closing the sub and sub.
We can save this now
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 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,
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.
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.