Truncate & Round
TRUNC: https://support.microsoft.com/en-us/office/trunc-function-8b86a64c-3127-43db-ba14-aa5ceb292721 TRUNC(number, [num_digits]) ROUND: https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c ROUND(number, num_digits) As a Finance & Accounting Specialist, I incorporated the TRUNC and ROUND function because our excel billing numbers had trailing numbers after two decimals while our billing numbers on the client invoices only shows up to 2 decimals. When it comes to reporting our numbers of what we sent out to the client, then we must report those numbers that only goes up to 2 decimals. This can be done as shown below