Finally, I want to show you one last function, which is the MIN function.
Basically, I want to have in a single cell Whatever would be the minimum value,
I mean the lowest value we're likely to see over the course of that 12 months.
Now in this small spreadsheet like this,
you can just kind of spot the fact that January's the bad month.
But if things changed if you added travel expenses for
instance to go home in July or if you had some other changes that were
unexpected in the other expense line that might change and
in bigger spreadsheets with larger columns it might be hard to keep track of that,
but I want to use this as an illustration of the minimum function.
This is an example of using a built-in function
to show a primary result you want to keep your eye on.
In this case,
it's to what extent do I go into the hole with this flaw of expenses and
need to be prepared to finance that either through credit or some other method.
So in this case, what I'll do is say, equals the MIN function.
And MIN will also take an array as an argument or a range of cells.
In this case, the cells that I'm interested in are B13 and
with the colon I'll indicate the end of the cell range,
which is in this case is M 13.
And when I hit the Enter key, the result picks the lowest number that we
spotted before from January, meaning that I need to be prepared to finance
my San Fransisco adventure, at least to the tune of $2,300.
So that's it.
This is very simple spreadsheet model, used to plan out expenses
associated with a possibility of a job opportunity in San Francisco.
It's not a model that I would necessarily keep, but
it does illustrate some of the elements of what we'll see in models that are used for
more elaborate and difficult business decisions in future sessions.
Also I hope that for those of you who are new to Excel, you saw some of the basic
shortcuts and techniques for navigating and building a spreadsheet.