## 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 )

any-value (any)

## Return Value

Decimal: The decimal equivalent of any-value if a recognizable number, or 0 if not. If any-value is blank (e.g., `""`), the result will be a blank Decimal value.