On Tue, 2 Jun 2009 10:53:31 -0700, "Rick" wrote:

It's module1. I was trying to use it in the commission column. when I moved
it to another column it worked. go figure. Thanks for all your help!

Rick

Glad you got it working. Although I doubt that moving a properly formed
formula from one column to another would have gotten rid of a #NAME error.
--ron