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 parentheses & 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 2009 and 2011, and payee is not MTA or Fandango, and category is food, shopping, or entertainment, then show "Awesome Transaction." If transaction is 2012 or later and subcategory is not Alcohol, then show "Late Transaction." If year of transaction is 2008, then show "Early Transaction". For everything else, show "CRAP Transaction" ----------- Step 1 - Write formula in plain English ----------- Step 2 - Reposition Arguments ----------- Step 3 - Add Parenthases and Commas ----------- Step 4 - Substitute English with Excel Syntax ----------- Step 4B - Including Cell References ----------- Step 5 - Paste after removing white space