| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of incentive
If an agent sales the policy of Rs. 35600 in a month, & the incentive slab is
if an agent sale the policy between 25000-40000 then the agent is eligible for Rs. 1000 incentive amount So kindly help me how can I do this by using formula?????????? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculation of incentive
You can have different incentive slabs like 0-25000,25000-40000,40000 and above
A1 = total amount =LOOKUP(A1,{0,25001,40001},{0,1000,1500}) If this post helps click Yes --------------- Jacob Skaria "9324982442" wrote: If an agent sales the policy of Rs. 35600 in a month, & the incentive slab is if an agent sale the policy between 25000-40000 then the agent is eligible for Rs. 1000 incentive amount So kindly help me how can I do this by using formula?????????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need an incentive form with id#,name, days, bonus, bonus, tot. | Excel Discussion (Misc queries) | |||
| Rebate incentive - Multiple tier payback - Confusing if Statement | Excel Discussion (Misc queries) | |||
| How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
