Postal formula

Giganews Newsgroups
Subject: Postal formula
Posted by:  omutumo (omutumo.288b9m_1148334901.3869@excelforum-nospam.com)
Date: Mon, 22 May 2006

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 :)

--
omutumo
------------------------------------------------------------------------
omutumo's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34681
View this thread:http://www.excelforum.com/showthread.php?threadid=544474

Replies