Get Decimal Part of a Number: Methods & Examples

To get the decimal part of a number, subtract the integer part from the original number. For example, the decimal part of 7.82 is 0.82, because 7.82 − 7 = 0.82. This article explains the different ways to extract the fractional part in math, spreadsheets, and programming, along with common pitfalls and practical examples.

Formula

The decimal part (also called the fractional part) of a number x is found by:

Decimal part = x − floor(x)

where floor(x) rounds x down to the nearest integer. For positive numbers, floor(x) is simply the digits before the decimal point. For negative numbers, floor(x) rounds away from zero (e.g., floor(−2.3) = −3), which makes the decimal part always non-negative.

Variables:

• x – the original number (any real number)
• floor(x) – the greatest integer less than or equal to x
• Decimal part – the fractional remainder, always between 0 (inclusive) and 1 (exclusive)

Worked Example

Using the default value from the calculator, x = 7.82:

1. Find floor(7.82) = 7 (since 7 is the largest integer ≤ 7.82).
2. Subtract: 7.82 − 7 = 0.82.
3. The decimal part is 0.82.

The calculator shows 0.82, confirming the result. For negative numbers, say x = −2.3: floor(−2.3) = −3, so decimal part = −2.3 − (−3) = 0.7. Note that some people instead use truncation (removing the sign), which would give −0.3; the difference matters in programming.

Why the Decimal Part Matters

Separating the integer and fractional parts is useful in many real-world situations:

• Time conversion: 3.75 hours → 3 hours and 0.75×60 = 45 minutes.
• Currency: Splitting dollars and cents from a total like $12.34.
• Measurements: 5.5 feet → 5 feet and 6 inches.
• Data analysis: Identifying whether a value is an integer or has a fractional component.
• Graphics and layout: Positioning elements at fractional pixel coordinates.

Methods in Different Tools

The exact method depends on the tool you are using:

• Spreadsheets (Excel, Google Sheets): Use =MOD(A1,1) or =A1-TRUNC(A1). MOD returns the remainder after division by 1, which equals the decimal part for positive numbers. For negative numbers, MOD returns a positive result (e.g., MOD(−2.3,1) = 0.7), while TRUNC simply removes the fractional part (giving −0.3).
• Python: Use math.modf(x) which returns a tuple (fractional, integer). For negative numbers, it returns the fractional part with the same sign as the input (e.g., math.modf(−2.3) returns (−0.3, −2.0)). Alternatively, x % 1 gives the positive remainder.
• JavaScript: Use x % 1 for positive numbers (e.g., 7.82 % 1 = 0.82). For negative numbers, x % 1 gives −0.3, not 0.7. To get a positive decimal part, use x - Math.floor(x).
• SQL: Use x - FLOOR(x) for positive numbers, or x % 1 in some databases.
• Calculators: Many scientific calculators have an INT (integer part) or FRAC function. For example, pressing FRAC on 7.82 returns 0.82.

Common Mistakes and Misconceptions

One common mistake is confusing the decimal part with the number of digits after the decimal point. The decimal part is a value, not a count. For instance, in 3.14159, the decimal part is 0.14159, not 5 (the number of digits).

Another issue arises with negative numbers. In mathematics, the fractional part is usually defined as non-negative, so −2.3 has a decimal part of 0.7. However, many programming languages use truncation toward zero, giving −0.3. Always check the documentation for the tool you are using.

Rounding errors can also occur when dealing with floating-point numbers. For example, in binary floating-point, 0.1 + 0.2 is not exactly 0.3, so the decimal part might be 0.30000000000000004. In such cases, round the result to a reasonable number of decimal places.

How to Choose the Right Method

Choosing a method depends on your needs:

• Need a non-negative result? Use the floor-based formula (x − floor(x)).
• Working with positive numbers only? Simple subtraction of the integer part (x − trunc(x)) works fine.
• Need both integer and fractional parts? Use a built-in function like math.modf in Python or divmod in other languages.
• Handling floating-point precision? Round the result to a specific number of decimal places to avoid tiny errors.

Limitations of the Formula

The formula works for all real numbers, but there are a few edge cases:

• Integers: The decimal part of any integer is 0 (e.g., 5 − floor(5) = 0).
• Very large numbers: Floating-point precision may cause the integer part to be slightly off, leading to a tiny non-zero decimal part for what should be an integer.
• Negative zero: In some languages, −0.0 may appear, but it is equivalent to 0.

Frequently Asked Questions

How do I get the decimal part in Excel?

Use the formula =MOD(A1,1) for positive numbers. For negative numbers, this returns a positive decimal part (e.g., MOD(−2.3,1) = 0.7). If you want the sign to match the original number, use =A1-TRUNC(A1).

What is the difference between fractional part and decimal part?

They are the same thing. Both refer to the portion of a number after the decimal point, expressed as a value between 0 and 1. Some authors use “fractional part” in a mathematical context, while “decimal part” is more common in everyday language.

Why does my programming language give a negative decimal part for negative numbers?

Many languages use the remainder operator (%) which truncates toward zero. For example, in JavaScript, −2.3 % 1 gives −0.3. To get the mathematical fractional part, use x - Math.floor(x).

Can I get the decimal part without using floor?

Yes, for positive numbers you can simply subtract the integer part: x - Math.trunc(x). For negative numbers, this gives a negative result, so if you need a non-negative value, use floor.

How do I get the number of digits after the decimal point?

That is different from the decimal part. To count digits, convert the number to a string and count characters after the decimal point, or use logarithms if you need a mathematical approach. For example, 3.14159 has 5 digits after the decimal point, but its decimal part is 0.14159.

What is the decimal part of a negative number like -1.5?

Mathematically, it is 0.5, because −1.5 − floor(−1.5) = −1.5 − (−2) = 0.5. However, some programming languages would give −0.5 if they truncate toward zero. Always clarify which convention you need.

Related

• Low Voltage Calculator: Voltage Drop and Basics
• Electrical Work Done Calculator: Voltage, Current and Time
• Grams to PPM Calculator: Convert Mass to Concentration

in x | Number | - | 7.82 | -1000000 | 1000000
out dec | Decimal part | - | x - floor(x) | 4
out int | Integer part | - | floor(x) | 0