Duke,

There a many ways of accomplishing this. One way would be (assuming your
data is in cell A1):

=A1+INDEX({5,10,15,20},MATCH(A1,{0,25,100,250},1))

HTH,
Ryan

"Duke" wrote:

I would like a formula that will add preset amounts to another amount.
If my cost for an item is <$25 I would like to mark it up by $5, if it is
$25 but <$100 I would like to mark it up by $10, if it's 100 but <250 I
would like to mark it up by $15, etc.

Is there a formula that will do this for me? Thanks.