ExCel programming

[Guest]

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

 

[Guest]

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

 

[Tushar Mehta]

IF statements are most probably the wrong way to go. You should use the
VLOOKUP function. For an example of its use with a table see
http://www.cpearson.com/excel/pricing.htm