SheetFX
≡
<< Go back to all functions

DOLLAR

The DOLLAR function in Google Sheets is a powerful tool to format a number into the locale-specific currency format. Whether you're working with financial data, creating invoices, or analyzing sales figures, the DOLLAR function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: DOLLAR(number, [number_of_places])

Parameters:

  • number: The number to be formatted as currency.
  • number_of_places [Optional]: The number of decimal places to include in the formatted currency.

Step-by-Step Tutorial

  1. Using DOLLAR with a basic number:

    • Example: =DOLLAR(1234.567)
    • Result: $1,234.57

  2. Using DOLLAR with a specified number of decimal places:

    • Example: =DOLLAR(1234.567, 2)
    • Result: $1,234.57

Use Cases and Scenarios

  1. Financial Reports: Format monetary values in currency format for reporting.
  2. Invoicing: Display prices in the appropriate currency format for customers.
  3. Expense Tracking: Format expense amounts in currency format for easy understanding.

Related Functions

  • ROUND: Round a number to a specific number of decimal places.
  • TRUNC: Truncate a number to a specific number of decimal places.

Related Articles