Difference between revisions of "Manuals/calci/VALUE"
Jump to navigation
Jump to search
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =VALUE( | + | <div style="font-size:30px">'''VALUE (Text)'''</div><br/> |
| − | |||
where, | where, | ||
| − | *<math> | + | *<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 == | == Description == | ||
| Line 13: | Line 11: | ||
*VALUE function is used to convert a text containing numbers to a number string. | *VALUE function is used to convert a text containing numbers to a number string. | ||
| − | *<math> | + | *<math>Text</math> is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command. |
| − | *<math> | + | *<math>Text</math> can be a number, date or time values in proper formats. |
| − | *If <math> | + | *If <math>Text</math> is invalid, Calci displays #N/A error message. |
== Examples == | == Examples == | ||
| Line 26: | Line 24: | ||
|- class="even" | |- class="even" | ||
| class="sshl_f" |$1000 | | class="sshl_f" |$1000 | ||
| − | | class="sshl_f" | | + | | class="sshl_f" |08/2/2010 |
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 43: | Line 41: | ||
=VALUE(B1) : Converts date to its serial number. Displays '''40392.71486111111''' as the output. | =VALUE(B1) : Converts date to its serial number. Displays '''40392.71486111111''' as the output. | ||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|e_imlxiHnkE|280|center|VALUE}} | ||
| + | |||
== See Also == | == See Also == | ||
| Line 52: | Line 54: | ||
*[http://en.wikipedia.org/wiki/String_(computer_science) String] | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
*[http://en.wikipedia.org/wiki/Text_normalization Text Normalization] | *[http://en.wikipedia.org/wiki/Text_normalization Text Normalization] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 18: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.
is a text that represents a number.
Description
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.
- is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
- can be a number, date or time values in proper formats.
- If is invalid, Calci displays #N/A error message.
Examples
Consider the following examples that demonstrate the use of VALUE function:
| $1000 | 08/2/2010 | |
=VALUE(A1) : Displays 1000 as the output. =VALUE(B1) : Converts date to its serial number. Displays 40392.71486111111 as the output.
Related Videos
See Also
References