P
Phil
Hi all ... I need a little help with this lookup.
I need to find a bonus percent from a table where total sales are between a
low and high value in the table.
Here's an example of the bonus table:
0 49,999.99 1%
50,000 99,999.99 2%
100,000 199,999.99 3%
The table is quite a bit longer than this, which is why I'd like to find a
formula to perform the lookup, rather than go the nasty
IF..ELSEIF..ELSEIF..ELSEIF.. route.
Thoughts anyone??
Thanks - Phil
I need to find a bonus percent from a table where total sales are between a
low and high value in the table.
Here's an example of the bonus table:
0 49,999.99 1%
50,000 99,999.99 2%
100,000 199,999.99 3%
The table is quite a bit longer than this, which is why I'd like to find a
formula to perform the lookup, rather than go the nasty
IF..ELSEIF..ELSEIF..ELSEIF.. route.
Thoughts anyone??
Thanks - Phil