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?
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:
Example
The excel example sheet will help you to learn this with an example.
To get the training model, subscribe to the series below.
Comments (0)
There are no comments yet :(