price range look up

[projay]

Hi everyone, is their a way to do a price range lookup for invoicing.

For example:

If i sell coffee cups

if a customer buys:

12-20 it would cost 5.99 each

21-30 it would cost 4.99 each

So if i put in the Qty field: 13 it would give the range cost between 12-20(5.99).

If i put in the Qty field: 23(4.99).

You probably understand what i am trying to accomplish. Thanks again. Jay.

[comment]

See:

http://www.fmforums.com/forum/showpost.php?post/294096/

http://fmforums.com/forum/showpost.php?post/300768/