
TRUNC, MROUND and INT function in Google Sheets or Excel
The INT, MROUND, and TRUNC functions simplify numbers by truncating, rounding to multiples, or removing decimals without rounding.
The INT, MROUND, and TRUNC functions simplify numbers by truncating, rounding to multiples, or removing decimals without rounding.
ROUND rounds to the nearest value, ROUNDUP rounds up to the next value, and ROUNDDOWN always rounds down, truncating extra digits.