Trunc

How to use the TRUNC function in Microsoft Excel
The Excel TRUNC function returns a truncated number based on an (optional) number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) wi...