FIXED (PQL - xl)

This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text

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

Syntax

FIXED(number, OPTIONAL decimals, OPTIONAL no commas)

Function Arguments

Name

Description

Type

Optional

number

Number to round and convert to text

Number

decimals

Number of decimal places; if omitted, uses two places

Number

Y

no commas

Logical value whether not to use commas; if omitted or FALSE, returns with commas

StringOrNumber

Y

Comments

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