| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
% commision
I have following problem:
Salesmen give x% in discount If discount % is between 0-4% he gets 25% bonus If dscount is 5-9% he gets 20% If discount is 10-14% he gets 15% If discount is 15-20% he gets 5% If discount is 20% he gets 0% How can I make function for this. Can someone help Thanks Bogi |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% commision
=IF(A1<"",LOOKUP(A1,{0,5,10,15,20},{25,20,15,5,0} ),"")
'OR in %'s =IF(A1<"",LOOKUP(A1,{0,0.05,0.1,0.15,0.2},{0.25,0 .2,0.15,0.5,0}),"") If this post helps click Yes --------------- Jacob Skaria "Bogi" wrote: I have following problem: Salesmen give x% in discount If discount % is between 0-4% he gets 25% bonus If dscount is 5-9% he gets 20% If discount is 10-14% he gets 15% If discount is 15-20% he gets 5% If discount is 20% he gets 0% How can I make function for this. Can someone help Thanks Bogi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commision Rate by margin | Excel Worksheet Functions | |||
| Add to commision formula | Excel Discussion (Misc queries) | |||
| Commision calculation | Excel Worksheet Functions | |||
| calculating commision on sales | New Users to Excel | |||
| Calculating sales commision HELP!!!!!!! | Excel Worksheet Functions | |||
Linear Mode
