if not too many start with the largest using nested if's
=if(a2100,4,if(a280,3,""))
or use a table with the VLOOKUP function. Look in HELP index



--
Don Guillett
SalesAid Software

"aem" wrote in message
...
Limited excel formula knowledge. Trying to create a formula based on a
dollar amount input to give you a specific output. I'm trying to use this
in
a self created cost / sell estimate form. If I input a range between $1 &
&100 in the cost cell then I want a sell price to reflect a mark up of
100%.
If the input range is between $101 & $300 then I want a sell price to
reflect
a mark up of 50%. If input range is between $301 & $500 then I want a
sell
price to reflect a mark up of 30%..... and so on. This is probably not
too
complicated for most but like I mentioned above.....Any help is great.