EXCELlent Ones Consulting Skip to Content Skip to Search

Print  |   | Download PDF

Max

Very often I work on Financial Models for startups and established organizations. When creating a model I use various functions to summarize what is happening in the organization. The Max function is one that I used from time to time to quickly determine the largest number in a range of values. Using this function beats the alternative of sorting a range.

1. Here is a list of unit sales for each month in a given year

2. Next we will type in the function =Max(Range)

a. Range is B8:M8

3. Very quickly the Max function has determined the maximum sales in the given range


Footer

Email: info@excellentones.com | P.O. Box 160493 | Brooklyn, NY 11216 | Phone: (347) 763-1035 | Fax: (718) 228-7859

All rights reserved. Copyright 2014 Excellent Ones Consulting LLC.