SheetFX
≡
<< Go back to all functions

DECIMAL

The DECIMAL function in Google Sheets converts the text representation of a number in another base to base 10 (decimal). Use this function when you need to convert numbers from a different base to decimal format.

Function Syntax and Parameters

Syntax: DECIMAL(value, base)

Parameters:

  • value: The text representation of a number in another base.
  • base: The base of the number to convert.

Step-by-Step Tutorial

  1. Converting a number from another base to decimal:
    • Example: =DECIMAL("101010", 2)
    • Result: 42

Use Cases and Scenarios

  1. Binary to Decimal Conversion: Convert binary numbers to decimal format.
  2. Octal to Decimal Conversion: Convert octal numbers to decimal format.
  3. Hexadecimal to Decimal Conversion: Convert hexadecimal numbers to decimal format.

Related Articles