=IF(A1<5.01,A1*3,IF(A1<15.01,A1*2,IF(A1<30.01,A1*1 .5,"")))

"Aaron" wrote:

Hi,

I'm trying to make myself a handy worksheet to figure mark up on the items
that I sell. I want to make it so that there is only one box to enter a cost
of an item into, and then based on the dollar amount, the selling price is
calculated and displayed in another window. The problem that I'm having is
that I don't know how to, or if it's even possible, to assign perameters into
one formula. So, if this isn't making any sense, here's my chart that I'm
working from:

cost value multiply by
$.01-5.00 3
$5.01-15 2
$15.01-30 1.5
ETC...

So, if I have an item that costs me $4.00, I want to multiply that item by 3
to get my selling price. But if an item costs me $6.00, I only want to
multiply that value by 2.

Hopefully this can be done so that I can just have one box that I enter a
cost amount into to get my correct selling price instead of having to pull
out a calculator every time I need to do this.

A response is much appreciated.

Aaron