DECIMAL()

Decimal from any value

Returns the Decimal equivalent of the value if it is a recognizable number, or 0 if not. If the value specified is blank (for example, ""), the result will be a blank Decimal value.

Sample usage

DECIMAL(4) : 4

DECIMAL(10 / 3) returns 3. In AppSheet, a Number (10) divided by a Number  (3) always produces a Number (3). In this example, the DECIMAL() function merely converts the Number result (3) to a Decimal value (3.0).

(10 / DECIMAL(3)) returns 3.33. In AppSheet, a Number (10) divided by a Decimal (3.0) always produces a Decimal (3.33). In this example, the DECIMAL() function converts a Number (3) to its Decimal equivalent (3.0).

(DECIMAL(10) / 3) returns 3.33. In AppSheet, a Decimal (10.0) divided by a Number (3) always produces a Decimal (3.33). In this example, the DECIMAL() function converts a Number (10) to its Decimal equivalent (10.0).

DECIMAL("4.2") returns 0 (0.0). AppSheet recognizes quoted raw text values in certain formats as Date, DateTime, or Time values. In this example "4.2" is recognized as the date, April 2 (of the current year). A Date value has no Decimal equivalent, so 0 (0.0) is returned. This (mis-)interpretation of the input only affects raw text values; an input from a column value or the result of another expression would not be so affected.

DECIMAL("14.2") returns 14.2. Unlike the preceding example, the quoted raw text value of "14.2" does not correspond to a valid Date, DateTime, or Time value, allowing DECIMAL() to work with the given text and to give the expected result.

DECIMAL("Hello!") returns 0, as the input value in no way resembles a numeric value.

DECIMAL("") returns a blank Decimal value.

Syntax

DECIMAL(value)

  • value - Any value.

See also

DATE() 

DATETIME()

NUMBER()

TEXT()

TIME()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false