ExCel programming

J

Jae

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
 
J

Joel

If statements format is the test value then if true or false.

referencing a differnt worksheet the format is 'Sheet1!A1

so for your case

=if('sheet2'!A1 < .7, 'sheet2'!A2 * 15.00,if('sheet2'!A1 < .8, 'sheet2'!A2 *
16.00,if('sheet2'!A1 < .9, 'sheet2'!A2 * 17.00, 'sheet2'!A2 * 18.00)))

This will give the following results
x <.7 commision is 15.00
..7 <= x < .8 commision is 16.00
..8 <= x < .9 commision is 17.00
..9 <= x commision is 18.00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top