View Single Post
  #5   Report Post  
 
Posts: n/a
Default

A different approach
=SUM(--(A10)*316.25,--(A155000)*(INT(A1/1000-55)*5.75),--(A1100000)*(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.