View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
9324982442 9324982442 is offline
external usenet poster
 
Posts: 1
Default 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??????????