Both of these make use of the MIN and MAX functions in Excel.
Let’s see how we can do this.
Let’s look at how to actually use it.
Let’s say we own a grocery store, and we take pre-orders from our customers.
However, the wholesaler insists that we order a minimum of 1500 for each fruit.
We can now apply the same formula to the other cells in the table byusing Excel’s AutoFill function.
We have now fulfilled our customers' orders while also meeting the wholesaler’s minimum requirements for each fruit.
Let’s look at this in more detail.
Let’s assume we own a business and offer bonus incentives to our employees.
However, we want to cap the bonuses they can receive every two months to $5000.
Then, use AutoFill to apply the formula to the remaining cells.
Finally, use AutoFill to complete your table.
The same method can be used for calculating a maximum number or a minimum number.
Now you know how to cap results or set a minimum value in your Excel spreadsheet!
