Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

DECIMAL Function in Excel

In this post, you will learn about the Decimal function in Excel and how to use it with-in an excel spreadsheet.

Syntax

=DECIMAL(number, radix)

The Decimal Function Syntax has two arguments

number – Holds the alphanumeric values.

radix – A number between the range 2-36 which hold the base/radix for the number to be converted.

Note:

  • Both the number and the radix argument is a required factor.
  • The word Alphanumeric represents the form that uses or is made up of both numbers and alphabets.

How does the Decimal Function work in Excel?

When the syntax accepts the values entered, the function takes place and converts the number/character into decimal numbers according to the radix.

  • Open a document with the necessary content or enter the numbers to be converted.
How to use DECIMAL Function in Excel?
  • In a new cell enter the syntax and highlight the necessary arguments to include them in the function.
How to use DECIMAL Function in Excel?
  • Press enter to display the answer.
How to use DECIMAL Function in Excel?
  • Use the fill handle to apply the function to the remaining data.
How to use DECIMAL Function in Excel?

The alphanumeric value you are using in the Decimal function must be a valid character with the given radix.

Important points:

The following are the most commonly used radix values.

Radix/ baseRadixRange of Alphanumeric values
Binary20 – 1
Octal      80 – 7
Decimal        100 – 9
Hexa decimal        160 – 9 and A – F
Hexatri decimal   360 – 9 and A – Z
  • Only the values between the above-assigned ranges for their respective radix values will be accepted by the syntax.
  • The radix argument is a non-case sensitive.
How to use DECIMAL Function in Excel?
  • The function returns #NUM! due to one of the following reasons,
  1. The radix value is less than 2 or greater than 36.
  2. The value in the number argument is not recognized by the syntax (eg : =,+,<,>,””,….).
  3. The number of characters in the number argument is greater than 225.
How to use DECIMAL Function in Excel?
  • And the function returns #VALUE! due to one of the following reasons,
  1. The radix argument exceeds the character limit of 225.
  2. The radix argument contains a non-numeric value.
How to use DECIMAL Function in Excel?