AutoSave OFF Asus CIS101 BTS 3-starter Data Share Comments Home fx Insert Draw Page Layout Formulas Ev - O - 2 - A - Review 0 - View - Define Name v 3 Calculate Now By Trace Precedents a Trace Dependents FRemove Arrows Insert Function AutoSum Recently Financial Logical Used Text Date & Time Lookup & Math & Reference Trig More Functions EO Create from Selection Show Error Error Formulas Checking Calculation Options Calculate Sheet Check for Updates L M N Formula Builder Fiscal Quarter 0,9 310 351 314 x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. D2 x fx D 1 Product CategoryID SubCategoryID Product Name CategoryNameSubCategoryName OrderDate Fiscal Year 310 3/13/17 0:00 2017 346 3/13/17 0:00 2017 346 1 3/13/17 0:00 2017 336 3/13/17 0:00 2017 346 3/13/17 0:00 2017 311 3/14/17 0:00 2017 3/14/17 0:00 2017 3/14/17 0:00 2017 344 3/14/17 0:00 2017 312 3/15/17 0:00 2017 312 3/15/17 0:00 2017 330 3/15/17 0:00 2017 313 3/15/17 0:00 2017 3/15/17 0:00 2017 314 3/16/17 0:00 2017 311 3/16/17 0:00 2017 310 3/17/17 0:00 2017 311 3/17/17 0:00 2017 314 3/17/17 0:00 2017 311 3/17/17 0:00 2017 336 3/17/17 0:00 2017 311 3/18/17 0:00 2017 312 3/18/17 0:00 2017 311 3/18/17 0:00 2017 310 3/18/17 0:00 2017 312 3/19/17 0:00 2017 332 3/19/17 0:00 2017 311 1 3/19/17 0:00 2017 311 3/20/17 0:00 2017 332 3/20/17 0:00 2017 3/20/17 0:00 2017 313 3/21/17 0:00 2017 346 3/21/17 0:00 2017 346 3/21/17 0:00 2017 314 3/21/17 0:00 2017 350 3/21/17 0:00 2017 312 3/21/17 0:00 2017 312 3/22/17 0:00 2017 310 3/22/17 0:00 2017 3/22/17 0:00 2017 42 311 3/23/17 0:00 2017 Instructions Sales Summary InternetSales Products Categories SubCategories + Ready SalesCountry Canada France United States United States Australia United States Australia Australia Australia United States United States United Kingdom Australia Australia United States Germany United States United Kingdom Australia Australia Australia United States United States Germany United Kingdom United Kingdom United States Australia Germany United States Australia United States United Kingdom United States Australia Australia United States United States Australia Australia Germany SalesAmount $ 3,578.27 $ 3,399.99 $ 3,399.99 $ 699.10 $ 3,399.99 $ 3,578.27 $ 3,578.27 $ 3,374.99 $ 3,399.99 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,399.99 $ 3,399.99 $ 3,578.27 $ 3,374.99 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,399.99 $ 3.578.27 Insert Function fx SWITCH Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned. 311 Syntax SWITCH(expression, value1, result1,default_or_val ue2,result2....) Expression: is an expression to be evaluated. 346 More help on this function @ - - - + 100% AutoSave OFF Asus CIS101 BTS 3-starter Data Share Comments Home fx Insert Draw Page Layout Formulas Ev - O - 2 - A - Review 0 - View - Define Name v 3 Calculate Now By Trace Precedents a Trace Dependents FRemove Arrows Insert Function AutoSum Recently Financial Logical Used Text Date & Time Lookup & Math & Reference Trig More Functions EO Create from Selection Show Error Error Formulas Checking Calculation Options Calculate Sheet Check for Updates L M N Formula Builder Fiscal Quarter 0,9 310 351 314 x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. D2 x fx D 1 Product CategoryID SubCategoryID Product Name CategoryNameSubCategoryName OrderDate Fiscal Year 310 3/13/17 0:00 2017 346 3/13/17 0:00 2017 346 1 3/13/17 0:00 2017 336 3/13/17 0:00 2017 346 3/13/17 0:00 2017 311 3/14/17 0:00 2017 3/14/17 0:00 2017 3/14/17 0:00 2017 344 3/14/17 0:00 2017 312 3/15/17 0:00 2017 312 3/15/17 0:00 2017 330 3/15/17 0:00 2017 313 3/15/17 0:00 2017 3/15/17 0:00 2017 314 3/16/17 0:00 2017 311 3/16/17 0:00 2017 310 3/17/17 0:00 2017 311 3/17/17 0:00 2017 314 3/17/17 0:00 2017 311 3/17/17 0:00 2017 336 3/17/17 0:00 2017 311 3/18/17 0:00 2017 312 3/18/17 0:00 2017 311 3/18/17 0:00 2017 310 3/18/17 0:00 2017 312 3/19/17 0:00 2017 332 3/19/17 0:00 2017 311 1 3/19/17 0:00 2017 311 3/20/17 0:00 2017 332 3/20/17 0:00 2017 3/20/17 0:00 2017 313 3/21/17 0:00 2017 346 3/21/17 0:00 2017 346 3/21/17 0:00 2017 314 3/21/17 0:00 2017 350 3/21/17 0:00 2017 312 3/21/17 0:00 2017 312 3/22/17 0:00 2017 310 3/22/17 0:00 2017 3/22/17 0:00 2017 42 311 3/23/17 0:00 2017 Instructions Sales Summary InternetSales Products Categories SubCategories + Ready SalesCountry Canada France United States United States Australia United States Australia Australia Australia United States United States United Kingdom Australia Australia United States Germany United States United Kingdom Australia Australia Australia United States United States Germany United Kingdom United Kingdom United States Australia Germany United States Australia United States United Kingdom United States Australia Australia United States United States Australia Australia Germany SalesAmount $ 3,578.27 $ 3,399.99 $ 3,399.99 $ 699.10 $ 3,399.99 $ 3,578.27 $ 3,578.27 $ 3,374.99 $ 3,399.99 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 699.10 $ 3,578.27 $ 3,578.27 $ 3,399.99 $ 3,399.99 $ 3,578.27 $ 3,374.99 $ 3,578.27 $ 3,578.27 $ 3,578.27 $ 3,399.99 $ 3.578.27 Insert Function fx SWITCH Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned. 311 Syntax SWITCH(expression, value1, result1,default_or_val ue2,result2....) Expression: is an expression to be evaluated. 346 More help on this function @ - - - + 100%