Functions
TO_DOLLARS
Formats a number as a dollar amount
Try it
When to use it
When should I use TO_DOLLARS?
Use TO_DOLLARS to apply dollar currency formatting to a numeric value, making it display as a monetary amount in reports or dashboards.
Syntax
TO_DOLLARS(value)Examples
=TO_DOLLARS(5) // => 5
=TO_DOLLARS(3.14) // => 3.14
=TO_DOLLARS(0) // => 0