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 Locate Text With The FIND Function In Excel FIND returns the position of one piece of text inside another, ready to hand to MID. It is case-sensitive, and missing text gives an error rather than a… September 11, 2026 · Excel Formulas Extract Part Of A Text With The MID Function In Excel MID cuts a piece out of the middle of a cell by position. It also returns a short answer without warning when the cell runs out, which is… September 10, 2026 · Excel Formulas Convert Text To A Number With The VALUE Function In Excel A column of figures that refuses to add up is usually text, not figures. VALUE turns numeric-looking text back into a real number, and this shows what makes… September 10, 2026 · Excel Formulas Capitalise Text With The PROPER Function In Excel PROPER title-cases a whole column of names in one pass, with UPPER and LOWER covering the simpler cases. It starts a new word after every non-letter, so mcdonald… September 9, 2026 · Excel Formulas Count Non-Empty Cells With The COUNTA Function In Excel COUNTA counts every cell that is not empty, where COUNT takes numbers alone. A formula returning an empty string still counts, so two cells that look equally blank… September 9, 2026 · Excel Formulas Catch Errors With The IFERROR Function In Excel IFERROR replaces a formula's error with anything you choose, which is what keeps a dashboard readable. It also swallows the errors that mean you made a mistake, so… September 8, 2026 · Excel Formulas Round Numbers With The ROUND Function In Excel ROUND changes the value a cell stores, where number formatting only changes what that cell shows. Its decimal argument also accepts a minus sign, which rounds to the… September 8, 2026 · Excel Formulas Format A Number As Text With The TEXT Function In Excel TEXT turns a number or a date into the formatted string you actually want to read, using the same codes as the Custom number format box. The catch… September 7, 2026 · Excel Formulas