You have created a worksheet documenting sales over every quarter since the start of your company. Each column represents a quarter and each row represents a product you sell. Each cell contains the sales generated for that product. You want to find the highest sales figure for one of your products. Which formula will do this?

Question

You have created a worksheet documenting sales over every quarter since the start of your company. Each column represents a quarter and each row represents a product you sell. Each cell contains the sales generated for that product. You want to find the highest sales figure for one of your products. Which formula will do this?

Answer 1

To find the highest sales figure for one of your products in the worksheet, you can use the MAX function in Microsoft Excel. Here's how to do it:

1. Select the cell where you would like the highest sales figure to be displayed.

2. Type the following formula:
=MAX(range)

In the formula, "range" represents the range of cells where your sales data is located. For example, if your sales data is in cells B2 to E10, you would input B2:E10 as the range.

3. Press Enter to calculate the formula.

The cell will now display the highest sales figure from the specified range.

Note: The MAX function will return the highest numerical value from the range you specify. If the cells contain non-numerical data or blank cells, the MAX function will ignore them.