Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change.

In Excel, the formula bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell.

Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples: =MAX (B4:B13) returns the highest value in the list.