Create a simple formula to multiply and divide in an Excel spreadsheet. You can multiply two or more numbers in one cell or multiply and divide numbers using cell references.

Microsoft Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or when a formula refers to a cell that has 0 or is blank, …

Split a table into two separate tables, to add text between the tables or better formatting.

Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE to find the top 25 percent of incomes in a population.

When your formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error …

How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of …

This article describes the formula syntax and usage of the MOD function in Microsoft Excel. Description Returns the remainder after number is divided by divisor. The result has the same …

The default is #N/A. Remarks If there is more than one delimiter, then an array constant must be used. For example, to split by both a comma, and a period, use =TEXTSPLIT (A1, {",","."}). …

Word and Outlook use a three-character shortcut that inserts a full-width horizontal rule in your document or message. The appearance of that rule depends on which character you use, as …

Use sections breaks to divide and format documents of all sizes. For example, you can break down sections into chapters, and add formatting such as columns, headers and footers, page …