Difference between revisions of "Manuals/calci/VALUE"

Latest revision as of 17:06, 13 August 2018

VALUE (Text)

where,

is a text that represents a number.
- VALUE() converts a text string representing a number, to a number string.

VALUE(txt)

e.g. VALUE("$1760") returns 1760 as a result.

VALUE function is used to convert a text containing numbers to a number string.
$Text$ is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
$Text$ can be a number, date or time values in proper formats.
If $Text$ is invalid, Calci displays #N/A error message.

Consider the following examples that demonstrate the use of VALUE function:

=VALUE(A1) : Displays 1000 as the output.
=VALUE(B1) : Converts date to its serial number. Displays 40392.71486111111 as the output.

@@ Line 1: / Line 1: @@
-=VALUE(txt)=
+<div style="font-size:30px">'''VALUE (Text)'''</div><br/>
 where,
-*<math>txt</math> is a text that represents a number.
+*<math>Text</math> is a text that represents a number.
+**VALUE() converts a text string representing a number, to a number string.
-VALUE() converts a text string representing a number, to a number string.
 == Description ==
@@ Line 13: / Line 11: @@
 *VALUE function is used to convert a text containing numbers to a number string.
-*<math>txt</math> is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
+*<math>Text</math> is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
-*<math>txt</math> can be a number, date or time values in proper formats.
+*<math>Text</math> can be a number, date or time values in proper formats.
-*If <math>txt</math> is invalid, Calci displays #N/A error message.
+*If <math>Text</math> is invalid, Calci displays #N/A error message.
 == Examples ==
@@ Line 45: / Line 43: @@
 ==Related Videos==
-{{#ev:youube|e_imlxiHnkE|280|center|VALUE}}
+{{#ev:youtube|e_imlxiHnkE|280|center|VALUE}}
 == See Also ==
@@ Line 56: / Line 54: @@
 *[http://en.wikipedia.org/wiki/String_(computer_science) String]
 *[http://en.wikipedia.org/wiki/Text_normalization Text Normalization]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]