21. MIN MAX: The biggest and smallest. Startup and investor excel model training

Intro to Excel model training- MIN MAX

This is part of a series on Excel model training focused on helping founders and investors to actually enjoy and get proficient in excel. It’s such an important skill to have, and there’s no excuse to not be able to do all the ‘advanced’ stuff, let alone the basics.

This is a pragmatic course where you will only learn the most useful things; those that I actually use regularly. We’ll go through the obvious applications, but also include some hacks I’ve developed over the years.

To get the excel example for this and all the other instalments, subscribe with the pretty box on the right and you’ll get the excel tip of the day sent directly to your inbox. Within a month and ten minutes practice, you’ll be a boss in no time.

You can join up to the training here.

What’s the point of MIN and MAX?

MIN finds the smallest, MAX finds the biggest. MIN, MAX, Right?

 So the simplae example is to make a list of numbers and you write =MAX(1,2,3,4,5) and it returns 5. If you write min then it’s 1.
That’s kinda handy write for hacking a little calculation, doing some basic data analysis.
But you can use MIN and MAX within formulas to do some cool stuff!
Being a boss at excel is knowing how to be sneaky and combine things in interesting ways,

How do I do these things you speak of?

By now I don’t think I need to break down how to do the basics or MIN and MAX. You must be getting pretty good.

So MIN and MAX are useful if you want to show negative or positive numbers. If you write:

=MIN(formula,0)

You will never show a formula result that is greater than 0. In this case you only show a resut that is less than 0. So negative numbers.

=MAX(formula,0)

This will only show positive numbers greater than 0. Cool, right?

Now let’s say you have a company that makes money. You tell your investors you will always pay the a dividend which is the same or greater than what you paid before. You would use MAX for this. In fact one of the exercises you are going to do is just that!

For a complex calculation, I use min in a formula to calculate the net operating losses of a startup. See below:

min.png

Example

The excel example sheet will help you to learn this with an example.

min max 1.png

min max 2.png

To get the training model, subscribe to the series below.

Get in the game

Free tools and resources like this shipped to you as they happen.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Also published on Medium.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.