O
omutumo
Hi,
I am trying to write a formula that automatically calculates postal
costs for items depending on their weight. However, there is one part
thats a bit more complicated.
If the item is over 1000grams the courier charges an additional £0.89
per 250g. The rest of the formula is easy (just using nested script and
<= functions) but I can't figure out how to do this in a similar manner
(ie. I don't want to have to write lots of ridiculously long nested
scripts!). grrr.
Thanks in advance for any help you can give me
I am trying to write a formula that automatically calculates postal
costs for items depending on their weight. However, there is one part
thats a bit more complicated.
If the item is over 1000grams the courier charges an additional £0.89
per 250g. The rest of the formula is easy (just using nested script and
<= functions) but I can't figure out how to do this in a similar manner
(ie. I don't want to have to write lots of ridiculously long nested
scripts!). grrr.
Thanks in advance for any help you can give me