“VALUE”
Used for – “VALUE” function in MS Excel is
used converts a text string which should be one of the find the constant/date/time
format which is recognised by MS Excel and excel than converts that constant
into a number.
Syntax – VALUE(Text).
Example – Following example will help to
understand of VALUE formula,
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
=VALUE(“12/12/2017”)
|
||||||||
2
|
=VALUE(“$115”)
|
||||||||
3
|
=VALUE(“15:15:00”)
|
||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
43081
|
||||||||
2
|
115
|
||||||||
3
|
0.635417
|
||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
Thus
we see that this formula results only in the form of a number against a
specified text.
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.