I'd create a commission table as a couple columns, Spread and
Commission. Then next to your Spread calculation, you can place a
Vlookup which references the spread number and the commission table.
The table could be on a different worksheet if necessary.

See VLOOKUP under help.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=527839