Excel Comparison
ROUND vs ROUNDUP vs ROUNDDOWN in Excel and Google Sheets
ROUNDUP goes away from zero; ROUNDDOWN goes toward zero. INT(-2.1) was -3 here, but ROUNDDOWN(-2.1,0) stayed -2. The midpoint 2.5 went to 3, not to even.
1 tutorial tagged “round”.
ROUNDUP goes away from zero; ROUNDDOWN goes toward zero. INT(-2.1) was -3 here, but ROUNDDOWN(-2.1,0) stayed -2. The midpoint 2.5 went to 3, not to even.