Numbers

Average A Range With The AVERAGE Function In Excel AVERAGE decides your denominator for you. A blank cell leaves it alone while a zero joins the sum, so the same column can honestly produce two different answers. September 12, 2026 · Excel Formulas Cut Decimals With The TRUNC Function In Excel TRUNC removes the decimals instead of weighing them. It agrees with INT on every positive number and disagrees with it on every negative one, silently. September 11, 2026 · Excel Formulas