Download the example workbook
In this Article
This tutorial will demonstrate how to calculate the decimal part of a number in Excel and Google Sheets.
Calculate Decimal Part of Number
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.
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.
Next, simply subtract the integer value found above, from the number to calculate only the decimal value.
Calculate Decimal Part of Number in Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.