How do I add 5 to amounts <25, 10 to amounts 25<100, etc?
 

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.

How do I add 5 to amounts <25, 10 to amounts 25<100, etc?
 

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.

How do I add 5 to amounts <25, 10 to amounts 25<100, etc?
 

On Mon, 6 Mar 2006 15:11:44 -0800, 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.

You didn't cover amounts exactly equal to 25 and 100, so I've assumed
a "="

=A1+IF(AND(A1=100,A1<250),15,IF(AND(A1=25,A1<100 ),10,5))

I didn't know whether your "etc." comment meant you have other ranges.
If so just adjust to taste.

HTH

Richard Buttrey
__

How do I add 5 to amounts <25, 10 to amounts 25<100, etc?
 

This is exactly what I'm looking for....Thanks for all your help guys!!!

-Duke

"Richard Buttrey" wrote:

On Mon, 6 Mar 2006 15:11:44 -0800, 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.

You didn't cover amounts exactly equal to 25 and 100, so I've assumed
a "="

=A1+IF(AND(A1=100,A1<250),15,IF(AND(A1=25,A1<100 ),10,5))

I didn't know whether your "etc." comment meant you have other ranges.
If so just adjust to taste.

HTH

Richard Buttrey
__