DECIMAL (PQL - xl)

This function converts the text representation (of a number in specified base) into a decimal number

  • Library: PQL \ Spreadsheet \ Math & Trig
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

DECIMAL(number, radix)

Function Arguments

Name

Description

Type

Optional

number

Refers to any combination of valid alpha-numeric characters according to the base. This value is not case sensitive

StringOrNumber

radix

This value must be an integer and it should be greater than or equal to 2 (binary) and less than or equal to 36

Number

Comments

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