See one crack at this using non-array formulas
as responsed in your earlier thread ..

A sample construct is available at:
http://www.savefile.com/files/2697802
AutoCalc_AgentsCommissions.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---