Difference between revisions of "Manuals/calci/VALUE"
Jump to navigation
Jump to search
| Line 43: | Line 43: | ||
=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:youube|e_imlxiHnkE|280|center|VALUE}} | ||
| + | |||
== See Also == | == See Also == | ||
Revision as of 15:49, 14 May 2015
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.
Related Videos
EmbedVideo does not recognize the video service "youube".