"Break even" generally implies two opposing trends. Where they meet is the
'break even' point. You have supplied only one 'trend'. Can you expand on
the problem?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Connie" wrote in message
...
Hello,

Is there a formula to calculate a break even point? Scenario: Rate
ranges
are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper has
load that weighs 990 lbs. What is the break even point to move the load
forward into the next cheaper range.

Hope that makes sense.

Any help appreciated.