"Niek Otten" wrote
Why leave that out? That was a useful addition.
....
Pl disregard this line:
(The above presumes a simple "flat" comm. rate structure,
not a complex "tiered" one)
My 2nd thought then was the line might arouse confusion rather than add
clarity.
Didn't want that to happen, certainly not on Christmas day, Niek <g
Maybe not in layman's terms, so maybe you could provide an example of
both.
Ah, think it's much better (and easier) to point to
JE's excellent treatment on the subject at his:
http://www.mcgimpsey.com/excel/variablerate.html
or, the direct link to the commissions example at:
http://www.mcgimpsey.com/excel/varia...ml#commissions
Merry Christmas, Niek !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--