Hello and welcome to our new video
In this video we are going to learn about two formulas
which are Floor and Ceiling
Now what do we understand from floor and ceiling?
From floor we understand floor
From ceiling we understand ceiling fan
So today we are going to see how these two formulas work
So first of all I open excel
In this file you can see some names and salary
Now many times if there is any other number in place of
salary
So suppose when we divide it
We don't know whether the output will come in decimal or not
If it will come in decimal and we don't want it in decimal
Then what will you do?
So this formula helps us
So here one number is given 24679
If I want to divide this number from 4
And I don't know what will be the result
But I want the result that whether it will come in decimal
or not
So how will it be?
So let's divide it
So first of all I put equals to to divide
So when I divide it from 5
So I get 4935.79
But I don't want it in decimal
So now you have to use either floor formula or ceiling
formula
Now if you use floor formula
So what will it do?
It will subtract some numbers from the formula
Like 4932 or 4934
So it will subtract some numbers from the formula
Where there is no decimal value
So if I use ceiling formula, it will give 4930 or 4940
So this is what floor and ceiling do
So let's apply it
Now I know it is 4935
So let's apply ceiling formula
I have double clicked it
And now it is G7
Now it will take two things
First thing is column
Second thing is the number from which you want to divide
Like I want to divide from 5
So this is 24680
See which formula I used
And what I said in ceiling formula
It will add something in 24679
But what did it do here?
It added 24680
If I see the rest, it is the same
So all the numbers that we have
If I divide this number from 5
There should not be any decimal value
So I put sign of equals
And divided it from 5
See 4936
So now we know how ceiling formula works
Same thing will work in floor formula
Like I show you floor formula
You have to write floor
You have to double click it
So I said this is the number
And I will divide it from 5
So what did it give here? It gave 24680
So it will give the number below
So I said enter
So it gave 24675
So we know that 24675 is a number
When you divide it from 5
It will not give you any decimal value
So let's divide this number from 5
Let's see what we are thinking is right
It is also possible that it will give you a decimal value
So it is very important to cross check
So I put sign of equals
Selected this number
And divided it from 5
When I divided it from 5
It gave 4935
So what I got clear from this
I got clear that
After putting ceiling formula
Sorry not ceiling formula
We are putting floor formula
After putting floor formula
I got clear that
I will not get any decimal value
So you can use it
You don't need values in decimals
When you divide something
You think you don't need decimals
Then you should use floor and ceiling formula
I hope you like this video
If you have any doubt
Then play this video again
And And And what to do?
Keep practicing
I will meet you in next video