The Shir Substitution Method (WRASP)

1. Write out entire formula in plain English and indent with tabs for easy viewing
2. Reposition arguments until they are in the correct order
3. Add parenthases & commas to ensure proper order of operations (PEMDAS) and argument separation
4. Substitute English with proper Excel syntax
5. Paste into formula bar after removing extra white space (find & replace)


NESTED IF CHALLENGE QUESTION

If year of transaction is between 2007 and 2009, and payee is not MTA or Fandango, and category is food, shopping, or entertainment, then show "Awesome Transaction." If transaction is 2010 or later and subcategory is not Alcohol, then show "Late Transaction." If year of transaction is 2006, then show "Early Transaction". For everything else, show "CRAP Transaction"