<I have copied and pasted the UDF. How do I access it? I did not get an opportunity to name it. I copied it into Module1.

You copied it to the right place. You don't have to name it: it's named already (PercPerSegment)

An example: In your worksheet you have

A1, A2, A3 and A4 respectively:
0, 100, 500, 1000
B1, B2, B3, and B4: respectively:
0%, 2%, 4%, 5%
C1:750

Type these in a blank worksheet, so it's easier to follow

Now you want to calculate commission or tax for the 750 . This is the formula:

=percpersegment(C1,A1:B4)

It should give you 18, which is correct.

Don't hesitate to post again in this thread if you can't get it right.


--
Kind regards,

Niek Otten

"krismtx" wrote in message
...

Thanks in advance for your help.

I am struggling with a sliding commission scale as well.

I have copied and pasted the UDF. How do I access it? I did not get an
opportunity to name it. I copied it into Module1.

I have copied the http://www.mcgimpsey.com/excel/variablerate.html site
and tried to follow that step by step, and I am still confused, so I
tried the user defined function.

Thanks so much!

Kris


--
krismtx
------------------------------------------------------------------------
krismtx's Profile: http://www.excelforum.com/member.php...o&userid=33462
View this thread: http://www.excelforum.com/showthread...hreadid=531821