Google Sheets DECIMAL Function: Syntax, Examples & Tips

value:
The number you want to convert from a specified base to decimal.

base:
The base of the number system for the value. This must be an integer between 2 and 36.

What is a DECIMAL Google Sheets Formula?

The DECIMAL function in Google Sheets is a useful tool that converts a number in a given base (radix) to its decimal (base 10) equivalent. This function is particularly handy when working with numbers in different numeral systems, such as binary (base 2), octal (base 8), or hexadecimal (base 16).

In simpler terms, the DECIMAL function allows you to take a number represented in a different base and convert it into a standard decimal format that is easier to understand and work with.

A Practical Example

Imagine you are working with a list of binary numbers and you want to convert them into decimal numbers for easier calculations:

Binary Numbers Table:

You want to convert these binary numbers into their decimal equivalents.

DECIMAL Formula

To achieve this, you would use the DECIMAL function as follows:

=DECIMAL(A2, 2)

In this formula:

• A2 is the cell containing the binary number you want to convert.
• 2 is the base of the number system you are converting from (in this case, binary).

Result of the Formula

When you apply the DECIMAL formula to the Binary Numbers Table, the output would look like this:

Why Use DECIMAL?

The DECIMAL function is beneficial because it simplifies the process of converting numbers from different bases into a format that is universally understood. This can be particularly useful in fields such as computer science, engineering, and mathematics, where different numeral systems are frequently used.

Key Takeaways:

• DECIMAL: A Google Sheets function that converts a number from a specified base to its decimal equivalent.
• Versatile: Can be used with various bases, including binary, octal, and hexadecimal.
• Simplifies Calculations: Makes it easier to work with numbers in different numeral systems by converting them to a standard format.
• Common Use Cases: Ideal for computer science applications, data analysis, and any scenario where numeral system conversions are necessary.

The DECIMAL function is an essential tool for anyone working with different numeral systems in Google Sheets, providing a straightforward way to enhance data analysis and calculations.

Happy spreadsheeting!