### Excel Magic Trick 704: Analyzing Problem and Building Robust Solution.

See how to analyze a problem and find all the possibilities that exist, then build a robust solution. See Nested IF functions, the AND function, VLOOKUP function, the ROWS function and Data Validation drop-down list to create a formula for calculating an Invoice fee based on multiple categories. Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Length:
13:08