Multiplying numbers in Excel isn't always the easiest thing to do, but it can be done. Here's how to do it in four ways, depending on what you need to multiply.

The formula is =B2:B10-F2:E10 or =B2:B10F2#. Excel uses the pound sign (#) to reference a spilled range, and that’s what will appear if you build the formula by selecting the cells F2:F10 , as shown ...