| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
try this idea within another if for comfort or corporate
=C12*(0.05+IF(C121000000,0.01,IF(C12500000,0.005 ,0))) -- Don Guillett SalesAid Software "yy" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
Did you try it?
=if(comfort, thisformula,thatformula) -- Don Guillett SalesAid Software "yy" wrote in message ... 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 "Don Guillett" wrote: try this idea within another if for comfort or corporate =C12*(0.05+IF(C121000000,0.01,IF(C12500000,0.005 ,0))) -- Don Guillett SalesAid Software "yy" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
ya, but the amount get is different.
"Don Guillett" wrote: Did you try it? =if(comfort, thisformula,thatformula) -- Don Guillett SalesAid Software "yy" wrote in message ... 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 "Don Guillett" wrote: try this idea within another if for comfort or corporate =C12*(0.05+IF(C121000000,0.01,IF(C12500000,0.005 ,0))) -- Don Guillett SalesAid Software "yy" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
IF ? you can fully explain, perhaps I can be of further help. However, I
don't read minds. -- Don Guillett SalesAid Software "yy" wrote in message ... ya, but the amount get is different. "Don Guillett" wrote: Did you try it? =if(comfort, thisformula,thatformula) -- Don Guillett SalesAid Software "yy" wrote in message ... 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 "Don Guillett" wrote: try this idea within another if for comfort or corporate =C12*(0.05+IF(C121000000,0.01,IF(C12500000,0.005 ,0))) -- Don Guillett SalesAid Software "yy" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looking for best system to process intensive excel spreadsheets | Setting up and Configuration of Excel | |||
| How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
| Microsoft should put operating system on hardware not software | Excel Discussion (Misc queries) | |||
| excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
| System doesn't load Systray | Excel Discussion (Misc queries) | |||
Hybrid Mode
