Difference between revisions of "Manuals/calci/VALUE"

From ZCubes Wiki
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...")
(No difference)

Revision as of 21:46, 24 October 2013

VALUE(txt)

where txt   is the text enclosed in quotation marks that want to convert.


It converts a text string that represents a number to a number.


VALUE


Let’s see an example in (Column1 Row 1)

I.e.=VALUE(C1R1)

=VALUE(“$4760”) is 4760


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 4760 4760
Row2
Row3
Row4
Row5
Row6