hello and welcome to our new video
today we are going to talk about
percentage formulas
whenever we talk about percentage formulas
we get confused
if someone asks you
that how much is 3% of 500
you start thinking
you start opening calculator
so how to do these things in excel
we are going to talk about this
so someone
asked you to calculate 7%
it will be 400
first you calculate
10%
it will be 40
after that
you calculate 5%
it will be 20
like this
it happens
with everyone
unless you are not that strong
so in this video
we are going to see
how to use percentage formulas
and how easily
you can do this
where will this help
when you prepare marks sheet
we need to convert percentage
and tell students
that how much did you score
so we are going to see this
so let's open excel
you will get some data
for example
Rahul Rohila
total marks out of 500
50 score
33 score
I have put column
what is in column A
what is in column B
there are two ways to calculate percent
one is
we tell excel the format
that we are using
percentage format
it will be easy for us
we will see how easy it is
second way is
without telling percentage
we take it out of formula
formula will not be there
simple calculation
we will use this calculation
first one
you will see
total marks
and score
we have to take out percent
in this cell
we will take out percent
without telling excel
that we are using percentage
so for this
you have to do
any calculation
after that
B into 100
divided by A
this is the formula
for taking out percent
I have put column B, column C, column A
so that we can easily
know what we are doing
in column B
we have to do
50 multiply 100
divided by 500
so we will get percentage
so here
for B
we have to select this cell
J12
after that
multiply
multiplied by 100
this star sign
is multiply sign
after that we have to divide
for dividing
there is a question mark
above it
you have to press that button
it is called oblique
in column A
we have to select
500
simply you have to
enter
10%
so 50
divided by 500
10%
now we have to
tell excel
that we are using percentage
formula
you can see
here
you have to
select percentage
now you have to
simply B divided by A
B is our score
so you have to select
sorry I have not put
equal sign
after that I have to select
divide by A
A is 500
so directly we have selected this cell
then we have to
6.60%
see it has shown us percentage
so this is more attractive
so what we have to do
whenever we try to find something in percentage
then
we have to tell excel
that what we are going to do
so this thing
I hope you have understood
this is same thing
but we have twisted it
we have to find
33%
what will be 10% of 500
so how to do this
simply
I have written
formula
if you want to find score
then you have to use this formula
if you want to find percentage
then you have to use this formula
here two things were given
total marks and score
so we have easily found percentage
here two things are given
total marks and percentage
here we have not given score
so this is slight change
so what we have to do
A is 500
I have selected it
cell name is shown in name box
simply we have to select it
after that what we have to do
multiply by C
C is percentage
so you have selected it
then you have to press
this divide sign
100
after this you have to enter
it will tell you
what will be 33% of 500
165
now here
one thing you have to remember
this 10%
convert it in percentage
then this
A multiply C formula
will work
if you click on
this cell
simply you have to
convert it in percentage
as I have done it
from here
so
after this
what we have to do
multiply by C
A is 500
multiply by C
I have to put star sign
in C
I have to enter 10%
so I will get
10%
of 500
10% of 500
50
change the value
if I
enter 90
then it will change
to 18%
if I enter 66
then it will change
to 13.20%
so you can
change the value
I hope
you understood
how to use percentage in excel
I hope
you understood
I will meet you in next video
till then
keep practicing