Hi

Start here
http://www.mcgimpsey.com/excel/variablerate.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


<ovemal@yahoo.no> wrote in message news:1132222762.048095.60560@f14g2000cwb.googlegroups.com...
> Hi
> I'm trying to make a pricelist for shipping that is getting to
> complicated for using the If function and I don't get it to work
> properly. Or at least the way I try to build it, it looks really messy
> and it will bee a pain for other people to maintain it on next update.
> The price list is more or less like this, in sheet one.
>
>
> A b c d
> Fixcost variable cost
> Up to 5m 200
> Up to 8m 300
> Over 8m (and less than 10Gton) 500
> Between 10 and 50Gt 1000
> If over 50t then
> Up to 300NT 2000 2 (for each N ton up to 300)
> Next 400NT 2000 1, 5 (for each N ton between 300 and 700)
> Over 700NT 2000 1 (for each N ton over 700)
>
> In sheet 2 the table looks like this
> A B C D E F
> Name boat Class Length Gross Ton Net Ton Price
> 1 Lea Cargo 8 13 7
> 2 Deap Pass 43 145 43
> 3 Sea Cargo 37 107 40
> 4 Water Cargo 15 18 17
>
> I will bee very grateful for any suggestions that will help me with
> this.
>
>
> thanks
>
> regards
>