Hello and welcome to our new video. In this video we are
going to talk about four functions which are round
function, round up function, round down function and m
round function.
Now we are going to see what these functions do and what
they work on.
So first of all we open excel.
And from here I open excel.
What is here is that a person's data is given to me.
Like here there is a name Rahul Rohila and here his salary
is written.
From January month to December.
And we also know that we often hear that government
employees get a basic salary.
And apart from the basic salary they get other allowances.
What comes in those other allowances?
DA comes, HRA comes, house rate allowances.
So the house rate allowances given here is 13.48% of basic
salary.
So what are we going to do?
First of all we are going to use the formula of AutoSum.
We will get 13.48% of basic salary.
And we will do the same thing manually.
We will do the total manually.
And the one which we will do in total will be done by
AutoSum.
So we will see how much difference is there.
The second thing which we are going to do is we are going
to apply the formula of round.
Whichever result we get.
So here we can see that from January to December I have the
data.
Salary is 18,327.
And the house rate allowances given here is 13.48%.
So what I have to do?
First of all I have to find out that 13.48%
How much will be 18,327?
So that I get to know that how much house rate allowances I
get.
So for this we don't have to do anything.
What we have to do is we have to mark the equation.
We have to multiply this HRA with the basic salary.
We have to multiply it with this.
So we have taken this.
The name of this cell is E2.
After that we have to multiply it with this.
With D2.
And we have entered it.
So the result which I got is 2470.
Now does this accurate result come or not?
Let's check this also.
2470.
Let's increase the decimal from here.
This kind of result is going to come.
Because I have done this before.
I was doing it.
That's why it showed me 2470 directly.
But when you do it for the first time, you will see
something like this.
Because all the places have the same number.
In every month there is 18327.
And here we have to take out 13.48.
So all this will be the same.
So what I do from here?
I drag it down like this.
One thing is done.
And we are going to do the same thing here.
Here we will do.
We do the same thing here.
We put the equation.
And we take this.
E2 is our house rent allowances.
We multiply it with this.
With 18327.
And this is our 2470.4796.
I drag it down like this.
Now what we have to do?
We have to do this.
You must have seen in math.
The value after the decimal is above 5.
So what we do?
For example, here 2470 is written.
And what is after the decimal? 4796.
If there was a value above 5 instead of 4.
6 or 7.
So what do we assume?
We round it and assume 2471.
So what are we going to do from here?
We are going to remove these decimals from here.
So I do it from here.
Here we get options.
In the number group, to increase the decimal from here.
We have the option to decrease it.
So I decrease it.
I have decreased it.
And here I.
I apply the same thing to everyone else.
2470.
Now what do I have to do?
First of all,
I have to calculate the sum.
Now I know that it is 12 months.
So I simply put this.
Take any number and multiply it by 12.
So I will get the answer.
29646.
So the total allowances from January to December is 29646.
We do the same thing here.
You can calculate it manually.
I apply the formula here.
Sum formula.
So I apply it here.
Request to sum.
And I take the first cell.
And then I take the last cell.
G13.
And I close it.
And I have 29645.7552.
How much is coming here? 29646.
How much is coming here? 29645.
Actually this is wrong.
One thing we have to remember.
Here I have decreased the decimal.
But when it takes the total.
Like I multiplied 2470 by 12.
So it will not take 2470.
Like I do here.
I write 2470 and multiply it by 12.
You can see the difference.
Here it is 29644.
And here it is 29646.
We have decreased the decimal.
But when Excel will multiply it by 12, it will also take
the decimal.
But we do not have to show the number difference.
So I correct it here.
Otherwise, how will I show the round?
So Here I have 2470.
So I multiply it by 12.
Because it is 12 months.
Here it is 29640.
And here I took the total.
So it is 29645.7552.
How much is the difference between these two?
It is 5.755.
This is the difference.
Now what we have to do?
Now we have to
I will show you.
First I have decreased the decimal.
Now we have to increase it.
Here we have to apply the formula of round.
How does the round work?
What is the meaning of rounding the value?
So here
I have written 2470.
Just a second.
It is not F3.
Here it is.
From here we have to increase the decimal.
And I apply the same thing on all.
Okay.
Now what we are going to do?
Now we are going to apply the formula of round.
And before applying the formula of round,
I want to tell you one thing.
It takes two arguments.
The formula of round, the formula of round up, the formula
of round down, or the formula of m round.
Now I will apply the formula of round.
What you have to do?
In front of this formula, you have to write the formula of
round.
Okay.
And in this way, here, it is saying that I want the number
first.
And secondly, I want the digit of the number.
Now what is the meaning of the digit of the number?
Okay. That is what I am going to tell you.
Okay. Like I put it here.
I put it here.
I put zero.
Okay. And then I enter.
When I enter, you will see all the values given after the
decimal are zero.
Okay.
Now what was the second argument?
Okay.
We should know that we have to round the first place.
Or we have to round the tenth place.
What does it mean?
Suppose I put zero in the second argument.
Okay.
What does it do?
The first place from the back
Okay.
The first place from the back
What does it do to the value of the first place?
It rounds it.
If I put zero in the second argument.
If I put minus one in the second round, then what does it
do to the things up to the tenth place?
It makes it zero.
Apart from this, it will also be used here.
It will also be used in the round up.
It will also be used in the round down.
If I put minus two, then what happens?
What is the meaning of hundred place?
After decimal, it becomes first place.
It becomes tenth place.
It becomes thousand place.
I am talking like this.
What happens here?
It becomes hundred place.
After this, if I put minus three in the second argument,
then what happens?
It becomes thousand place.
Apart from this, if I put minus four here, and I write here
it becomes ten thousand place.
It becomes ten thousand place.
It works like this.
I will show you.
Let's do it in the center.
What I have done here?
I have put the formula of the round and I have put zero.
What do we do now?
Let's put minus one instead of zero.
It has shown you the same thing.
If I put minus two, then what is it going to do?
It is going to round.
What is the meaning of this?
It was four, seven, nine, six.
What is it doing?
It is putting zero and showing the values after decimal. 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0