I’m no wizard when it comes to spreadsheets but I feel I can hold my own when it comes to intermediate level functions. I learned one today that I can see being supremely useful in my nerd-laden future: If/Then functions!
Lets say you tutor for three different subjects: Chemistry, Calculus, and Physics. You aren’t any good at Chemistry so you only charge 5 bucks a session. You’re pretty decent at Calculus (so long as there aren’t any Riemann sums, infinite series or integration by partial fractions) so you charge 10 bucks for these sessions. Physics is your science of choice so you provide top notch service at a premium price of 15 dollars. You want your spreadsheet to look pretty so you format the cells in column A as drop down menus, each menu item being one of the subjects you tutor. Now wouldn’t it be nice if, when you chose the subject you tutored, the amount due was displayed to the right in column B? That’s where if/then statements come in handy. They look like this: IF(aaa=bbb,ccc) which reads: if a equals b, then c. You can add more conditions to it by separating them with commas and adding another IF statement. Ours would look like this:
In our example it’s important to add the quotation marks to denote a string as opposed to a number. Also, strings are case sensitive so make sure you type the subject exactly as it appears in the drop down menu.