TRUNC Articles: Excel and Google Sheets

All resources related to TRUNC for Excel and Google Sheets.


Get integer part of a number
We can use the TRUNC function to remove the decimal part of a number and only get the integer portion. This post provides an step by step guide on how we can get the integer of a number. Figure 1: Using TRUNC to get integer portion of a number Syntax...