DOLLAR (PQL - xl)

This function converts a number to text using currency format, with the decimals rounded to the specified place

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

DOLLAR(number, decimals)

Function Arguments

Name

Description

Type

Optional

number

Numeric value to convert to text using the currency format

Number

decimals

Number of decimal places to maintain; if negative, the value is rounded to the left of the decimal point; if omitted, the function rounds to two decimal places

Number

Comments

This function is the same as the Microsoft Excel 'DOLLAR' function - using the same inputs, logic and outputs.