Hello and welcome to our new video
In this video we will talk about three formulas
First is for upper case
Second is for lower case
And third is to round figure any value
So if you have any data which is written in lower case
Or some data is written in upper case and lower case mix
And you have to convert that whole data in upper case at
once
Then how is it done
Or you have data of upper case
Which is written in capital and how to convert it in lower
case
Or if you have decimal values
Then how to convert it in round figure
So we are going to discuss these three things
We are going to do it practically
So let's see one by one
So first we have to open excel
I will open excel from here
I have some names written here
Rahul, Imran, Jishan
Now you will notice one thing
That here in Imran
Some words are like this
Some alphabets are like this
Some are written in capital
Some are written in small
It is written in all like this It is mixed
So what we have to do is We have to use upper formula
We want all our names
To be converted in upper case
So let's do it
First of all What we have to do is
We have to put sign of equals to
We know it Don't tell me again and again
To put formula We use equals to
And then you will write upper
It will suggest you
And after suggesting It is written
Converter takes string to all uppercase letters Now what is
string?
I will tell you the difference
Between character and string
If you write a single character
Like I wrote a
Like we saw in last video
We were writing grade
If I write a single alphabet
I will call it character
If I write more than one alphabet I will call it string
So here it says
Converter takes string to all uppercase letters Means you
put a string
And this formula Will convert it in upper case
So let's put We wrote upper
And then we put bracket
And then we wrote text
We don't write text
What do we do?
We put cell name
What is cell name here?
Do we have to put name of all cells?
Do we have to put formula again and again?
No, put in one cell
What should I do in the rest? Drag it
So we will do the same
We know that we have selected G4 And then I closed it
And I pressed enter
It is written Rahul
Now why is it big and why is it small?
I made it big so that it is visible
That's why it is visible
Now what we have to do?
Drag it
How do you see all the names? How do you see all the names?
I can see all of them
In capital
I make it bigger
So that it is visible
Now see
How was Rahul's L?
It was written in small
But now it is capital
Imran's M
Or A is written in small
But now it is in capital
And all this We converted it on one click
Now Let's see
Let me tell you one thing
Let's copy all the data
Ctrl C
And let's paste it in another sheet Let me show you
We went to another sheet
And here I selected any cell
And I did Ctrl V
What happened?
I couldn't see the data
So when you Use the upper case formula
Or any other formula
And copy and paste the data in another sheet
It doesn't work So what you have to do?
There is an option of paste special We saw it earlier in
the starting videos
Paste special
So we don't have to paste
We have to paste special
So what we have to do?
We went here Paste special
After going to paste special
We selected the values
You have to select the values
And click on OK
Now what happened? All the names
If we simply paste it
It doesn't get pasted
So we did paste special
In paste special We selected the values
Now you can see
How we copied and pasted
From one sheet to another sheet
With the formula Now let's go
I think it will be clear to you
How to use the upper case
Even if I have been given mixed letters
I can convert the upper case
From my formula Now it is already written in the upper case
You will ask me to do it in the lower case
So how to do it in the lower case?
It is also simple in the lower case
I will put the equal sign
And I will write
LOWER If your formula is correct
If you remember the name
For upper case, lower case
If you write LOW
It will suggest you
The formula is available with excel
You have to double click
You can see the lower
Double click on the blue background
It will automatically tell you
We have seen from the beginning
We do not work on the text We do not work on the values
We work on the cell
We will put the name of the cell
We selected it directly
Or you can write it manually
As I selected it directly
F7 came here I closed it
And entered
Now it is in small
Now I have to drag it down I have dragged it
I will increase the size
Now you can see
It was written in capital
It is in small letter
It was in capital
It is in small letter
You can do it in one click You can do it in upper case
You can do it in lower case Let's see the next thing
These two formulas are clear
The third formula is round
Let's see it here
32.56 32.56 45.78 After this
After this
I have to change the size
I will do it here
I will write here 45.89 I entered
I will increase the size from here So that you can see
45.89 I will write here 67.45 And after that
I will take more values
The difference between them
I will get here
Ok Now What happens in round figure?
We saw that After 45.5
If the number is above 5
Then what do we take? We take 46
For example, here 45.89 is written To round figure it
After this decimal, 8 is written
If the value is below 5
Like 1 or 2
Then what do we take for round figure? We take 45
But if it is above 5, then what do we take?
We take 46 Similarly, here 67.45 If I ask you to round
figure it, what will you do?
You will say that round figure will be 67
Right? In 89.01, round figure will be 89 What will happen
in 110.57?
It is possible to take 110
It is possible to take 111
So, simply what we have to do For round figure, there is a
formula
We have to assign equals to
And write here I have the round figure
And Here, we double click on round figure And it tells me
Tell me the number and then tell me the digit of number
Till where it has to be
So, we just write the number
We select this cell
And close it
You have entered too few arguments
For this function
So, we have to put one more argument
Here What do we do?
One second
Again and again, because I will select on any cell
It is taking the name of cell
We don't want this
We want G10
And Digit of number
We said
Zero Because we want round figure
So, we don't want any decimal
To come
We don't want any value
To come after decimal
Like 45.89
So, I don't want 45.89
I want either 45.89
Or 46.89
So, I will put zero here
Now, I will
Enter 46.89
Now, I will drag it
One second
Let's drag it
All the values I had
What happened?
All the round figure
Here, it was 67.45
Now, it is below 5
After decimal
So, it is 67.89
Decimal is zero
So, it is 89
Now, I said 110.57 You can take 110 or 111
So, both cases are possible
After this 132.13 What is taken in this? 132.
Why it is taken? Because after decimal it is 1.
If I change this 5, 3 and enter
So, see it changed 133 So, this was in today's video that
we learned about 3 formulas
We have seen round figure
How it is taken from formula
Upper case to lower case conversion I hope it will be clear
If you have any doubt then play this video again
Watch it multiple times
Watch last video also multiple times so that all the doubts
are cleared
I will meet you in next video
Till then if you have any doubt then play the video and
practice