Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to assign individual colours to each bar chart? sparjolly Charts and Charting in Excel 1 May 18th 07 01:52 PM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 2 October 28th 04 07:24 AM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 1 October 28th 04 05:21 AM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 1 October 28th 04 05:09 AM
Calculating commission schedule (will pay for help!) bootsy Excel Worksheet Functions 0 October 28th 04 04:53 AM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"