Re: I am trying to figure out how to add per 1000
- From: Robert_Steel@xxxxxxxxxxx
- Date: Tue, 12 Jul 2005 15:53:52 +0100
A different approach
=SUM(--(A1>0)*316.25,--(A1>55000)*(INT(A1/1000-55)*5.75),--(A1>100000)*(INT(A1/1000-100)*-0.75))
personal preference as to which you choose. This would be neater if you
wish to increase the number of price brackets.
hth RES
> It starts out at a flat fee of $316.25 for everything from 0 to
$55,000.00,
> and then adds $5.75 per $1,000.00 up to a maximum of $100,000 and then
> anything over $100,000 the rate drops to $5.00 per $1,000 up to 1
million.
>
> What I am attempting to do is place a number like $250,000 in a box and
have
> excel do the equation and automatically place $1,325.00 in another box.
.
- References:
- Prev by Date: Re: Sum product help needed with an extra variable please and than
- Next by Date: Re: Copy VLookup Values
- Previous by thread: Re: I am trying to figure out how to add per 1000
- Next by thread: RE: I am trying to figure out how to add per 1000
- Index(es):
