Lookup Function
 

I think I've seen this at one time but don't remember how to do it. I'd like
to compute the following type of schedule

0-500 0 percent
500-4999 15 percent
5000-9999 13 percent
10000-19999 11 percent
20000 9 percent
This isn't a simple lookup. For example for 15000
0 on first 500
15% on 4999-500 plus
13% on 9999-5000 plus
11% on 15000-10000.
Thanks for any help

Lookup Function
 

See this:

http://mcgimpsey.com/excel/variablerate.html

Look for the commissions example

Biff

"Michael" wrote in message
...
I think I've seen this at one time but don't remember how to do it. I'd
like
to compute the following type of schedule

0-500 0 percent
500-4999 15 percent
5000-9999 13 percent
10000-19999 11 percent
20000 9 percent
This isn't a simple lookup. For example for 15000
0 on first 500
15% on 4999-500 plus
13% on 9999-5000 plus
11% on 15000-10000.
Thanks for any help

Lookup Function
 

This was quite helpful. What do the -- do? Thanks again.

"Biff" wrote:

See this:

http://mcgimpsey.com/excel/variablerate.html

Look for the commissions example

Biff

"Michael" wrote in message
...
I think I've seen this at one time but don't remember how to do it. I'd
like
to compute the following type of schedule

0-500 0 percent
500-4999 15 percent
5000-9999 13 percent
10000-19999 11 percent
20000 9 percent
This isn't a simple lookup. For example for 15000
0 on first 500
15% on 4999-500 plus
13% on 9999-5000 plus
11% on 15000-10000.
Thanks for any help

Lookup Function
 

Also on the same site:

http://mcgimpsey.com/excel/formulae/doubleneg.html

Biff

"Michael" wrote in message
...
This was quite helpful. What do the -- do? Thanks again.

"Biff" wrote:

See this:

http://mcgimpsey.com/excel/variablerate.html

Look for the commissions example

Biff

"Michael" wrote in message
...
I think I've seen this at one time but don't remember how to do it. I'd
like
to compute the following type of schedule

0-500 0 percent
500-4999 15 percent
5000-9999 13 percent
10000-19999 11 percent
20000 9 percent
This isn't a simple lookup. For example for 15000
0 on first 500
15% on 4999-500 plus
13% on 9999-5000 plus
11% on 15000-10000.
Thanks for any help