I am working on a spreadsheet for work where it will calculate commissions to
be earned based on my sales. There is a table that I have to use to determine
what the percentage would be, how would I write an equation for that. For
example, the equation would have to say: if say D3 was = or < than %, use
cell# whatever and then have a sum in there. The table is on another sheet in
the document so that would have to be there too.

Basically, the way that my commissions are calculated is that we have to
take what I sold in any given month and find out what percentage of my yearly
plan it is. That will give me the percentage that I locate on the tables.
When I have this %, I then have to take my monthly salary and multiply the
percentage to get the amount of my commission.

Any help would be greatly appreciated.
--
Jocelyn Marsden
Sales Executive
Xerox North American Inside Sales
( 1-866-479-0828 Intelnet: 8*280-2937
Fax: 1-866-350-1125