Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Compute commission VLOOKUP Excel 2010

Posted on 2011-10-30
Medium Priority
Last Modified: 2012-05-12
Any suggestions on how to compute the commission with the following information.

Name      Dept         Sales           Commission Amount
Mary         2          4,005.78              
Sue         1             500.00             
Paulo         1             500.01             
Rena          2          1,000.00             
Stanford      2             250.00       

 TOTAL               $  6,255.79        $                 -         

                                                Dept 1                 Dept 2
Sales >= 0 and <=300               2%                         3%
Sales >300 and <=500              3%                         5%
Sales >500 and <=1000               6%                         7%
Sales >1000                              7%                         8%

Table to Compute Commission

Question by:perla1962
  • 2

Author Comment

ID: 37052510
This is not a homework actually I don't go to school. You making a mistake I tried but I got an erro message.
LVL 50
ID: 37052521
Then why the stories about helping your father, helping your sister, doing it for your company???

Your questions are like a textbook progression from a simple Vlookup to more complex scenarios. Vlookup with False parameter, Vlookup with TRUE parameter, adding two Vlookups with False parameter, adding two Vlookups with True parameter, etc....

If it's not homework, then come out with the complete picture, instead of feeding one question after the other and adding more and more criteria.

Post your workbook with the whole layout. Then we can give you the final formula in one go.

But I'm still convinced it's homework. The scenarios, the progression of complexity, the whole thing has homework written all over it.

If you have tried to apply what you have learned, but get an error: What is the formula you have tried? What is the error?

Show some respect for the people who are trying to help you and put in some effort, too. Post a file with what you have done so far.

Author Comment

ID: 37052534
Very well I will show you my steps and the error message and if you guys can help me will be really appreciate.
LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 37053258

I see that you still haven't posted an example.

In any event, this article will provide you with a complete overview of VLOOKUP syntax, along with troubleshooting tips for solving the most common issues people tend to have with VLOOKUP:



Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question