ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   assign commission schedule to an individual (https://www.excelbanter.com/excel-discussion-misc-queries/148525-assign-commission-schedule-individual.html)

Mergerk

assign commission schedule to an individual
 
I have set up 2 commission schedules in Excel and I now want to assign a
schedule to individual people. How do I do this?

Don Guillett

assign commission schedule to an individual
 
You fail to give any detail but have a look in the help index for
IF

--
Don Guillett
SalesAid Software

"Mergerk" wrote in message
...
I have set up 2 commission schedules in Excel and I now want to assign a
schedule to individual people. How do I do this?



Mergerk

assign commission schedule to an individual
 
You are right. I did not give much detal as to what I really want to do.
I'm sorry. This is my first time doing this.
Here is the deal.
I want to use the commission schedule to calculate in a sales report. The
commissions vary by age and rate of commission. There are 4 people that will
use this schedule. Schedule 2 commissions also vary by age and rate and rate
of commission. This schedule has 6 people that will use this schedule.
Is there a way to set this report up so that when I type a persons name it
will go to the correct schedule and then when I put in an age the report will
calculate useing the correct commission information breakdown?
I hope that with this someone can give me a little help.


"Don Guillett" wrote:

You fail to give any detail but have a look in the help index for
IF

--
Don Guillett
SalesAid Software

"Mergerk" wrote in message
...
I have set up 2 commission schedules in Excel and I now want to assign a
schedule to individual people. How do I do this?





All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com