hi,
assuming that your quantity is in A1, try this...
=IF(A1600,(600*0.05)+((A1-600)*0.058),A1*0.05)
regards
FSt1

"skateblade" wrote:

Calculate the first 600 units @ 5c per unit, above 600 units calculate @ 5.8c
per unit