## Examples

`DECIMAL(4)`

: `0`

(0.0)

`DECIMAL(10 / 3)`

gives `3`

(3.0). 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))`

gives `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)`

gives `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")`

gives `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")`

gives `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!")`

gives `0`

, as the input value in no way resembles a numeric value.

`DECIMAL("")`

gives a blank `Decimal`

value.

## Syntax

`DECIMAL( `

*any-value* )

## Argument

* any-value* (any)

## Return Value

`Decimal`

: The decimal equivalent of * any-value* if a recognizable number, or

`0`

if not. If *is blank (e.g.,*

`any-value`

`""`

), the result will be a blank `Decimal`

value.## See Also

`APP()`

, `DATE()`

, `DATETIME()`

, `NUMBER()`

, `TEXT()`

, `TIME()`