Hello and welcome to our new video
till now we have covered a lot of excel
but one common problem
which we have seen many times
that is the problem of errors
we have seen many times that there is an error of hash name
or hash hash is written
or hash value is written
so why all these errors come
we are going to talk about this
in today's video
if you see any error like this
then how to resolve it
we get scared that why this error is coming
so we have some errors like this
let me open the excel file
here I have some data
name is there
subject is there
name is Rahul, marks are there
48, 80, 90
name is there, subject is there and marks are there
what is written on the side
5 types of errors in excel
these are commonly errors of excel
which we get to see
like hash name
or hash value
or hash reference
or div 0
or hash hash
so first of all
let's start with this
why this name error comes
in excel you will know
there are many formulas
for example
when we were doing auto sum
there we saw to get maximum number
to get minimum number
to get average
to get sum
you are writing sum
you wrote sim instead of sum
or you wrote mix instead of max
so in excel
that formula
you typed it wrong
you wrote mix instead of max
so when you go to find excel
there should be mix formula
but excel will not get mix formula
so it will give you
hash name error
let's do it here
what I do
I want to find
which subject
has maximum marks
so I put
equals sign
and I wrote
mix
it should be correct
but I mistyped it
and here I selected range
after that
I closed bracket
and I entered
so hash name error came
now
why hash name error came
because here
what we did
we typed wrong formula
so you have to remember
whenever you type wrong formula
you have to correct it
then only this error will go
now what I have to do
I will max it from here
will it be correct
it is correct
now let's see
so it told me
everything
89, 93, 82, 94
I will delete it
very good
now let's see
why hash value problem
hash value
comes because
as we know excel has
formats
this is general format
number format, currency format
short date, long date
we were doing short date thing
in last videos
so we saw this
like date format
so minus date format
from date format
if you want correct result
otherwise excel doesn't know about format
excel will pick any format
and you will get wrong output
so here
if your format is wrong
like you are adding two things
or you are multiplying two things
or you are doing subtraction or division
but their formats are different
like one is tax format
and other is number format
so if I multiply tax
in number or add tax in number
will it be correct
it is not possible
so what error is shown there
it shows hash value error
let's see
my tax
I will multiply it by 13
and see what answer I get
so here I will
put a question
here I selected excel
then I multiplied
and selected 13
then I entered
so what error I got
hash value
this is the same error
format is different
so if you get this error
then understand where is the problem
you are multiplying two formats
you are doing subtraction
so you have to see the format
and you can
change the format
so I will remove it
after this
next thing is reference
now what is the meaning of reference
like I will copy this
table
so
I have two tables here
I made it here
or make one more table
I have three tables
now in these three tables
I have to see the reference
now why this error occurs
so let's see
suppose I wrote
equals to
and I tried to sum
here
so I did sum
and I wrote
number 1
72
comma
33
and then I entered
you will say
105
but suppose
this is hash 20
suppose
this row
is deleted for some reason
like I delete it
see
hash reference
when we don't have data
and we give reference
like we gave reference
for this particular cell
but it is not a cell
so what error will it show?
it will show reference error
if you want to correct it
you will
give another name
like I gave
name of this cell
and then I entered
so result will come
so if you see hash reference
hash ref error
it means
that data is not available
so you can correct
that error
next thing is
div divided by 0
now why this error occurs
let's see division
I wrote equals to
and I took 82 and divided it
by 41
so result came
but suppose
this number is not here
and then I enter
82
one second
here
equals to
select it
and divide it
so error will come
hash div divided by 0
because I don't have any number
in this cell
so what does it mean?
if you don't have number, how will you divide?
if you can't divide, it will show error
so here divide
I will show you
one more thing
now it is correct
if you take any number
like I took F6
divide F6 by 0
then also error will show
so there are two cases
either you are dividing by 0
or in other case
data is not available
so in both cases
one second
remove it
so in both cases
error will show
apart from this
last thing
I will tell you why it comes
it came
I will show you here
I put formula
equals to sum
I selected range
from here to here
and I entered
311
it is here
now
what is this hash?
this error is very interesting
it can be seen many times
and it can be solved easily
the easiest way is
we know that our cell
has a particular size
it has a width
so if I am writing a long formula
and that long formula
is not coming in it
or output is not coming in that particular cell
then it will show me a hash error
so it can be solved easily
what you have to do is
increase the size of cell
after doing this
hash is removed
so I hope you have understood
that all the errors
how they are solved
you don't have to worry
about errors
because you know
what is the problem
like in name
if you type wrong formula
which error comes
name error
value error
when there are two different formats
text format and number format
I am multiplying them
or suppose there is a date format
or text format
there you will see
hash value
so you have to correct it
you know format changes from here
other than this
reference
and now I am checking
there is no data in that cell
so how it will do things
so what error will it show
after that
division I hope you have understood the types of errors in
this video, if you still have any doubts, then watch this
video again, I will meet you in the next video, till then
keep practicing.