For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

The easiest way to guarantee you select enough cells is to select the number of cells equal to the range difference. In the example, subtracting 8951 from 11859 results in a range of 2,908 numbers.

Tips If you just want to find the quotient of two numbers, use the forward slash, or "/", symbol. For example, to divide 10 by 2, type "10/2" (without quotes) into the cell, and then press "Enter." ...

To find the cube root of a number in Excel, you need to use a formula like this: =<first cell with number>^(1/3). Let’s say the number if given in the A1 cell.

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.