Excel Stuff

On Monday, we are going to be focused on mixed references (absoluting either the column or row and letting the other stay relative), LOOKUPS and IF statements.

Here is a pretty decent tutorial on VLOOKUP that I found on YouTube.  If nothing else, type up the example shown in the tutorial and try implementing it yourself so you can see how it "feels" when you are working with it...it always looks so much easier when someone else is doing it.



Here is a decent illustration of a basic IF statement.  The only thing that I don't really like about it, is that it would be better to have an assumption area with the bonus structure, in case it were to change.