Automated Pricing in Excel
This is an example of pricing with multiple pricing tables. In this example, the final price is based on the product's dimensions, the material, and finish. It is a combination of dollars and percentages. This was done utilizing existing Excel functions, no VBA or custom functions required. Let me see what I can do for your project.
About Me
I have been developing Excel application for a Fortune 100 company for over 15 years. I enjoy automating processes and creating applications to manage data. I understand whatever I create needs to be user friendly or people will not use the tool. I can create applications using basic Excel functionality, develop macros using Visual Basic, or creating a hybrid utilizing Excel and Microsoft Access. Below is a sampling of things I can help with: * Nested LOOKUP and IF-THEN statements * Database functionality using SUMIFS and COUNTIFS * Autofilters and Conditional Formating * Visual Basic * Trouble Shooting of formulas and code Whether you need help with an Excel formula or something more involved, I'm excited to help make your vision a reality.
