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

D

Duke

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
Click to expand...
would like to mark it up by $15, etc.

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

Ryan Poth

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
 
R

Richard Buttrey

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
would like to mark it up by $15, etc.

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

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
__
 
Top