Difference between revisions of "Manuals/calci/VALUE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''VALUE'''</font></font></font><font color="#484...") |
|||
| Line 1: | Line 1: | ||
| − | + | =VALUE(txt)= | |
| − | + | where, | |
| + | *<math>txt</math> is a text that represents a number. | ||
| − | + | VALUE() converts a text string representing a number, to a number string. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | VALUE(txt) | |
| − | + | e.g. VALUE("$1760") returns '''1760''' as a result. | |
| − | |||
| − | |||
| − | VALUE | + | *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>txt</math> can be a number, date or time values in proper formats. | ||
| + | *If <math>txt</math> is invalid, Calci displays #N/A error message. | ||
| − | + | == Examples == | |
| − | |||
| − | |||
| − | + | Consider the following examples that demonstrate the use of VALUE function: | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" |$1000 |
| − | | | + | | class="sshl_f" | |
| − | | class=" | + | | class="sshl_f" | |
| − | + | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" |08/2/2010 |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | + | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class=" | + | | class="sshl_f" | |
| − | + | | class="sshl_f" | | |
| − | | | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | =VALUE(A1) : Displays '''1000''' as the output. | |
| − | + | =VALUE(B1) : Converts date to its serial number. Displays '''40392.71486111111''' as the output. | |
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
| + | *[[Manuals/calci/TIMEVALUE | TIMEVALUE]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/String_(computer_science) String] | ||
| + | *[http://en.wikipedia.org/wiki/Text_normalization Text Normalization] | ||
Revision as of 16:25, 7 February 2014
VALUE(txt)
where,
- is a text that represents a number.
is a text that represents a number.VALUE() converts a text string representing a number, to a number string.
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.