Excel Forum

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

Got a Question? Ask it Here in the Forum.