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.
|