Welcome to Excel and Business Math Video Number 13.
In this video, we have two short topics.
We have to see how to convert a mixed number
to an improper fraction and an improper fraction
to a mixed number.
And we'll get to see how to do it by hand in Excel,
by hand, and in Excel.
Now I'm going to go open up PowerPoint and show
you live how to do this on a piece of paper.
Over here in PowerPoint we want to see
how to change an improper fraction to a mixed number.
And the steps are, first do the division,
then put the remainder over the denominator.
Our example, we're going to take the improper fraction 8/3,
and that is going to be equal to--
yes, you got it-- we're going to do old fashioned division.
The denominator, old fashioned division bar, and I'm
going to write the numerator 8.
And I have to ask the question, how many 3s are in 8?
Well, counting on my fingers, 3 and 3 is 6.
That means there are two 3s in 8.
That 2 is the whole number or integer part.
Now I have to say 2 times 3 is equal to 6.
And I subtract it to get the remainder.
So 8 minus 6, that gives me a remainder of 2.
Now I write it up here R2.
So it's whole number 2, remainder 2.
But now, put remainder over denominator.
That's the next step.
So we say, equals sign, write the whole number 2,
now we take the remainder, that's
the top part in the numerator of our fraction,
we write it, draw our fraction bar,
and now we put the denominator 3.
And there you go.
We have converted from an improper fraction
to a mixed number.
Now there's another way we can do this.
I'm going to write 8/3 equal, and I'm
going to draw a long fraction bar.
And in the numerator I'm going to say 3 plus 3 plus 2,
hey guess what?
That equals 8.
And then I'm going to put it over the denominator three 3.
Now I'm noticing there's two 3s in the numerator.
So there's a 3 there.
There's the second 3.
And there's a part of a 3.
So guess what?
I can write an equal sign and rewrite this fraction.
We'll write as the 3 divided by 3, that's this first 3,
plus the second 3 over 3, that's the second 3.
Then we say plus and here's the part, 2/3.
What's nice about this method is it becomes obvious.
3 divided by 3 is 1 plus 3 divided by 3 is 1 plus 2/3.
So we can rewrite this as 1 plus 1 plus 2/3.
And there we go.
Now we know 2 and 2/3.
Now I want you to remember from Video Number Eight,
any number divided by itself is 1.
This 3 divided by 3, 1.
This other 3 divided by 3, 1.
And we're left with 2/3 to add to 1 plus 1.
Now we want to move on to our next topic
and talk about how to change a mixed number
to an improper fraction.
Number one, we're going to have to multiply the denominator
and integer, then add the numerator
to get the new numerator, then put the new numerator
over the denominator.
Now we're going to take our same example, 2 divide by 2/3.
And here's step one, multiply denominator and integer.
So I'm going to draw a little arrow and a multiplication
symbol and an arrow.
That means multiply those two things.
We're going to write this off to the side,
3 times 2 then we have to add the numerator.
So I'm going to draw an arrow, a plus symbol, and another arrow.
Now remember, we had to step one multiplying
and now we have to add the result to the numerator 2.
So we say plus 2 and draw our fraction bar.
Now we simply list the denominator.
And there we go.
Equal sign, we get 6 plus 2 over 3 equals 8 over 3.
And there it is, our improper fraction.
Now let's look at another example, 13 and 1 divided by 2.
Let's convert this to an improper fraction.
So we say 2 times 13.
We write it off to the side.
Then we do our second operation, plus the 1
which is the numerator.
So we write it plus 1.
Draw a fraction bar.
Put the denominator 2 and then equals sign, let's see, 2 times
13, 26 plus 1, 27.
So we write 27/2.
And there it is, an improper fraction
from 13 and 1/2 mixed number.
All right, now we want to go over to Excel
and see how to do this in Excel.
Now we're over here in Excel on the sheet convert.
Now example one, we want to convert the improper fraction
8/3 to a mixed number.
Now this is just a single number.
If you want to enter it hard coding the numbers in,
that's fine.
I'm going to put the numerator and denominator into the cells
because there are actually two interesting functions--
quotient and mod.
We actually saw these functions back in Video Eight
when we talked about division.
And the great thing about the quotient function
is it can take a numerator and denominator
and give you just the integer part, which is what
we need for a mixed number.
So we're going to use the quotient function.
You can read the screen tip, returns
the integer part of division.
So numerator, there's that improper, larger
than the denominator numerator comma denominator there it is.
Close parentheses and enter, and there it is.
It gives us the whole number integer 2.
The remainder we use the mod function for that.
It has different argument names in its screen tip.
But number, that's the numerator comma divisor,
that's denominator.
And when I hit Enter, that's the remainder part.
So as an improper fraction, I'm going
to just do it for our number formatting example.
I'm going to get the 8 divided by 3.
Now, if I divide 8 by 3 and hit Enter,
that will get me the decimal.
But when I do the mixed number, I better
get exactly the same decimal.
Now there's two 2s here.
So let's pick the right one.
That's the integer part.
So I'm going to start my formula equals that's the integer.
And since 2 and 2/3 is a mixed number, that implies adding.
We simply add, get the remainder,
and divide it by whatever the denominator is.
Now notice the order of operations will work perfectly.
Division comes before addition.
And of course, Excel knows the order of operations.
So when I hit Enter, I have both as decimals.
But now let's properly format.
I'm going to select that cell Control-1.
Now in category, I want to come down to custom.
Now I'm going to highlight this and I
want improper single digit, that's the question mark,
slash single digit that's the question mark.
So there is, 8/3.
Click OK.
Now I'm going to click here Control-1.
And if we go to a fraction, I'm going
to show you a great trick.
And I did show you this earlier.
Any one that you select, if you want
to see how they constructed the custom number formatting
for that particular version, you can select it.
And I'm actually going to select the first one, come down
to Custom.
And notice, it will give us for that single digit
always pound, that'll give us the integer, and then
question slash question, that'll give us
single digits in numerator and denominator.
And that is what I would have typed out.
So that particular built in one works perfectly.
Click OK.
Now I'm going to check to make sure they're equal.
Equal sign, up arrow.
And equal sign is a comparative operator
to create our logical formula, up arrow, up arrow.
When I hit Enter, it tells me yes indeed they are both equal.
Remember those formulas don't look at the number formatting.
They look underneath at the underlying numbers.
Example two, oh, look at that, an improper fraction,
35 divided by 17.
There's the numerator and denominator.
I'll use the quotient function, get the numerator comma
the denominator, and this will give me
the integer or whole number part when I hit Enter, 2.
The remainder, I use mod tab, number
means the numerator comma divisor means the denominator.
And look at that.
There's a single remainder.
I'm eventually going to put the remainder over the denominator
so it looks like 2 and 1/17.
The improper fraction, there it is.
Enter.
Mixed number.
I'm going to say, hey, please give me
that whole number 2 plus there is the remainder divided
by the denominator.
Better give me exactly the same thing.
Now for the improper fraction, I want
double double, so Control-1, come down to Custom.
And I'm going to select question question slash
question question.
And there it is.
35/17.
Click OK.
Now I'm going to do it as a mixed number, Control-1.
Come down to Custom.
Come up here.
I want a pound to show the integer,
space question mark slash question question.
And there I have my 2 and 1/17.
Click OK.
Now I can see if they're equal.
And they better be equal.
Enter, and there it is true.
Now let's go down to look at our next two examples.
We want to convert a mixed number 2 and 2/3
to an improper fraction.
I listed them here.
You can hard code them.
In effect, the homework answers I did them three ways.
I did them as formula inputs, hard coding the numbers,
and writing them on paper.
All right, so a mixed number equals
there's the whole integer part plus
there's the numerator divided by the denominator.
And of course, Excel will calculate that correctly.
Let's go ahead and format this, Control-1, Custom.
And up here I'm going to say pound space question slash
question and Enter.
As we did it on paper or in PowerPoint,
3 times 2 plus 2, so I'm going to do that right here, equals--
there's the denominator, times.
There's the whole part.
That means we have two 3s plus the part that's not a whole 3,
our numerator 2.
So that would be the new numerator, 8.
Now we can simply to get our improper fraction, 8
divided by our denominator.
Control Enter, Control-1, Custom, type question mark
slash question mark.
There's my 8/3.
Click OK.
I can check to see if they're equal.
Is 8/3 equal to 2 and 2/3?
You bet.
If it came up false, I knew I did something wrong.
Now here's our next example, 13 and 1/2.
As a mixed number, it equals--
there's the whole integer part plus 1 divided
by 2, Control Enter, Control-1, Custom,
and in type I'll go pound space question mark
slash question mark.
Again, you can look through the built in ones
and use those if you'd like.
I like to type them in.
Click OK.
There is my 13 and 1/2.
The new numerator, denominator times the integer
plus the numerator equal sign there's the denominator times,
so we want to have 13 2s plus one extra.
That will be the new numerator.
So 27.
Improper fraction, we're going to take
27 divided by the denominator.
Control Enter, Control-1.
We need two in the top and one in the bottom.
So I'm going to put question question slash question.
And there it is.
Click OK.
Are they equal?
Equal sign, up arrow.
Equal sign as a comparative operator up, up.
And when I hit Enter, we have our truth.
All right, so that was a little bit
about converting mixed numbers to improper fractions
and improper fractions to mixed numbers, both in Excel
and we did it by hand over in PowerPoint.
There are four homework problems and some answers for you.
And of course, if you like that video
be sure to click that thumbs up, leave a comment, and sub.
Because there's always lots more videos to come from Excel
is Fun, including Video Number 14 where
we'll do another simple topic.
We'll convert decimal to a fraction and fraction
to decimal.
All right.
We'll see you next video.