The DECIMAL function in Google Sheets is a powerful tool designed to convert numbers from one base format to another, specifically transforming non-decimal numeral systems into the familiar base 10. This functionality is particularly useful for analyzing data from various numerical bases, enabling effective data manipulation and analysis in spreadsheets.

Syntax

DECIMAL(number, base)

• number: The text representation of the number you want to convert.
• base: The base of the number you are converting from, which must be between 2 and 36.

Example #1

=DECIMAL("1010", 2)

This function converts the binary number “1010” into its decimal equivalent, which is 10.

Example #2

=DECIMAL("1A", 16)

Here, the hexadecimal number “1A” is transformed into decimal format, resulting in 26.

Example #3

=DECIMAL("ZZ", 36)

This function converts the base 36 representation “ZZ” to decimal, yielding a value of 1295.

Error handling

• NUM!: This error occurs when the base parameter is not between 2 and 36.
• VALUE!: This error is displayed when the number parameter contains invalid characters not fitting the specified base.

Conclusion

The DECIMAL function is a crucial asset for users needing to convert numerical representations from various bases into decimal format. By understanding its syntax and applications, users can leverage this function to enhance their data analysis capabilities and streamline their workflows in Google Sheets.