Calculate Decimal Part of Number – Excel & Google Sheets
Written by
Reviewed by
Download the example workbook
This tutorial will demonstrate how to calculate the decimal part of a number in Excel and Google Sheets.
Calculate Decimal Part of Number
Calculate Integer
To calculate the decimal part of the a number, first we must calculate only the integer part. We can calculate the integer portion of a number using the TRUNC Function.
=TRUNC(B3,0)
You might also be familiar with the INT Function. The INT Function returns the integer portion of the number, which for positive numbers it the same as the TRUNC Function. However, for negative numbers, the INT Function rounds negative numbers down away from zero.
For this purpose, you probably want to use the TRUNC Function.
Calculate Decimal
Next, simply subtract the integer value found above, from the number to calculate only the decimal value.
=B3-TRUNC(B3,0)
Calculate Decimal Part of Number in Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.
