Excel Forum
Similar Content
How to Build a Simple Navigation Dashboard in Excel
Tutorial: Build a professional Navigation Dashboard in Excel that ANYONE can customize. You can add...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Guide to Creating Charts with a Macro in Excel
Tutorial: How to add, edit, and position charts in Excel using VBA. This tutorial covers what to do ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.