Hi,

Set up a rate table like
0.01 20%
100 19%
500 18%
....
10,000 2%

suppose this is in the range M1:N20

then use a lookup function

=VLOOKUP(A2,$M$1:$N$20,2,TRUE)*A2

Where A2 contains the cost of an item.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Anna" wrote:

I am a small business owner and what I need is to price my inventory. Let's
say my lowest cost ($0.01) will be multiplied by 20%....and my highest cost (
$10.000) will be multiplied by 2%?
Is there a formula to do it and if yes,,,what it is?
Somebody suggested I should use the Conditional Formatting/Formula. Is it
the best for my need and if yes, how do I do it?
Can you give me more details?

Thanks in advance!