| 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
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? "Don Guillett" wrote: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
send it -- Don Guillett SalesAid Software "yy" wrote in message ... 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? "Don Guillett" wrote: 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. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
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. -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... send it -- Don Guillett SalesAid Software "yy" wrote in message ... 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? "Don Guillett" wrote: 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. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use tier system
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. "Don Guillett" wrote: 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. -- Don Guillett SalesAid Software "Don Guillett" wrote in message ... send it -- Don Guillett SalesAid Software "yy" wrote in message ... 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? "Don Guillett" wrote: 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) | |||
Linear Mode
