Formula for different calculation but in same column

[Mohanes]

Hi I I only know how to handle basic excel . My question is now I need to separate the commission amount. such as the first 15 pick up will get RM1.00 ( each) and the extra pick up will get RM2.00 (each) I mean more than 15/following pick up. ( Nature of business is collecting wastages from clinics) So now my problem is I am doing manually such as mines the first 15 and put it into a different column (15*1) and the balance into another column (e.g 2*15) Which I need to use two columns. what is the solution or way doing them in same column but with different calculation. Thank you

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

[Ace_XL]

This might help

http://www.excelforum.com/excel-form...lculation.html

[Pete_UK]

Suppose you have 17 (pickups) in cell A2. Then you can do this in B2:

=MIN(15,A2)*1 + IF(A2>15,A2-15,0)*2

Hope this helps.

Pete