My head hurts

**bfee317** · 10-29-2009, 07:22 PM

First of all I am a newbie:

I need help setting up a sales and commission tracker.

I have created 7 main colums. Date - Mobile # - Activation - Rate Plan - Data Plan - Accessory $ - Commission

So the first step is there are 3 list options I have loaded into a drop down list under Activation. They are New - Upgrade - Annual

Under Rate Plan the are 7 list options I inserted ie: $9.99 - $30.00

Under Data Plans the are 3 list options I inserted ie: $9.99 - $29.98

So here we go. Lets say I need to enter a NEW, $9.99 - $30.00 (rate plan), $9.99 - $29.98 (data plan).

The NEW pay out is different than that of an upgrade or annual sale and affects the commission depending on the price plan.

For instance:

A New $9.99 Rate plan pays $5

So I think I need to make a formula so the Rate Plan checks the Activation drop down (new, upgrade, annual) to see what the correct pay out is.

Please help.

Thanks

**stanleydgromjr** · 10-29-2009, 07:28 PM

bfee317,

Welcome to the Excel Forum.

Please post your workbook (or a sample if sensative information) - scroll down and see "Manage Attachments".

**martindwilson** · 10-29-2009, 08:09 PM

how about you actually ask a proper question?

my head hurts

so does mine but....
the answer would be...
drink less lol

**bfee317** · 10-29-2009, 08:13 PM

Originally Posted by martindwilson

how about you actually ask a proper question?

so does mine but....
the answer would be...
drink less lol

Not everyone is a drunk like you. If you don't understand my question than ask me.

**bfee317** · 10-29-2009, 08:14 PM

Here is the file

**randell.graybill** · 10-29-2009, 09:00 PM

http://www.excelforum.com/forum-rule...rum-rules.html

read it, follow it, and then ask for help.

Not even going to look at your request due to two reasons, your rude and you haven't followed the forum rules.

**DonkeyOte** · 10-30-2009, 03:41 AM

bfee317, sometimes humour is lost online so I will give you the benefit of the doubt.... however as outlined already I'm afraid

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Please modify your title at which point people will be able to assist you.

**royUK** · 10-30-2009, 05:21 AM

Also cross posted here

http://www.thecodecage.com/forumz/me...n-tracker.html

I suggest you take a couple of aspirin & read the forum rules whilst they take effect