 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006how to use tier system
hi i have a question, i am not sure what formula i can use to calculate this question, cause i am require to use the tier system for it: Commissions for airline tickets are based on a tier system. Comfort gets 5% commissions from the first $500,000 of ticket revenue, 5.5% from revenue between $500,001 to $1,000,000 and 6% for revenue above $1,000,000, for Corporate tickets revenue. As for Individuals tickets revenue, the commissions’ structure is 4.5% for the first $500,000, 6% from revenue between $500,001 to $1,000,000 and 7% for revenue above $1,000,000. Commissions for packaged tours are projected at 12% of packaged revenue. try this idea within another if for comfort or corporate =C12*(0.05+IF(C12>1000000,0.01,IF(C12>500000,0.005,0)))  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > hi i have a question, i am not sure what formula i can use to calculate > this [quoted text clipped - 8 lines] > between $500,001 to $1,000,000 and 7% for revenue above $1,000,000. > Commissions for packaged tours are projected at 12% of packaged revenue. ya can, but i need to add in another IF how. then can explain to me this part 0.005,0. i don't quite get it. thanks > try this idea within another if for comfort or corporate > =C12*(0.05+IF(C12>1000000,0.01,IF(C12>500000,0.005,0))) [quoted text clipped - 11 lines] > > between $500,001 to $1,000,000 and 7% for revenue above $1,000,000. > > Commissions for packaged tours are projected at 12% of packaged revenue. Did you try it? =if(comfort, thisformula,thatformula) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > ya can, but i need to add in another IF how. then can explain to me this > part [quoted text clipped - 18 lines] >> > Commissions for packaged tours are projected at 12% of packaged >> > revenue. ya, but the amount get is different. > Did you try it? > =if(comfort, thisformula,thatformula) [quoted text clipped - 21 lines] > >> > Commissions for packaged tours are projected at 12% of packaged > >> > revenue. IF ? you can fully explain, perhaps I can be of further help. However, I don't read minds. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > ya, but the amount get is different. > [quoted text clipped - 27 lines] >> >> > Commissions for packaged tours are projected at 12% of packaged >> >> > revenue. would u tell me for logical_test is put what value, value_if_true is put what, then if false is put what. or do u mind if i same my thing to u? > IF ? you can fully explain, perhaps I can be of further help. However, I > don't read minds. [quoted text clipped - 30 lines] > >> >> > Commissions for packaged tours are projected at 12% of packaged > >> >> > revenue. send it SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > would u tell me for logical_test is put what value, value_if_true is put > what, then if false is put what. or do u mind if i same my thing to u? [quoted text clipped - 37 lines] >> >> >> > Commissions for packaged tours are projected at 12% of packaged >> >> >> > revenue. This is obviously HOMEWORK for a course you are taking. We do NOT do homework here. I suggest you use a lookup table( see help for vlookup) or the formula I provided. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > > send it [quoted text clipped - 39 lines] >>> >> >> > Commissions for packaged tours are projected at 12% of packaged >>> >> >> > revenue. ya, i never say it's not a homework. and because i not sure how to apply the formula that's why i come here to ask for help. and i never ask you to help me do my work, i am just asking for any formula that can be used cause i am not sure, but thanks anyway for your help. > This is obviously HOMEWORK for a course you are taking. > We do NOT do homework here. I suggest you use a lookup table( see help for [quoted text clipped - 42 lines] > >>> >> >> > Commissions for packaged tours are projected at 12% of packaged > >>> >> >> > revenue. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.