Not trying to be argumentative, but your sample data does not support your
desire for a "proportionate" scaling. For example, price of 9.99 could cost
3.99 to ship, and cost of 10.01 wouls cost 5.99 to ship, while cost of
exactly 10 would be free to ship.

Please give either a percentage of the cost (with a minimum if you desire)
or a schedule of postage ranges for as far out as you wish them to go......

thanks,
Vaya con Dios,
Chuck, CABGx3



"stewartlogan" wrote:


Hey folks - sorry to barge in.

I am a new user of excel and am trying to create a 6500 product
spreadsheet for a website i am building.

What i want to do is as follows:
I have a column with my retail price. I want to create a column with my
postage price. I want the postage price to be proportionate to the
retail price.

Example, if retail is less than £5 postage is £2.99. If retail price is
more than £5 but less than £10, postage price is £3.99, if retail price
is more than £10 but less than £15, postage price is £5.99 and so on
and so forth.

Question is, how to i put this in a formula. Tried lots of ways but
keep messing it up.

I would really really appreciate someone helping me out!!

Thanks in advance
Stewart


--
stewartlogan
------------------------------------------------------------------------
stewartlogan's Profile: http://www.excelforum.com/member.php...o&userid=31371
View this thread: http://www.excelforum.com/showthread...hreadid=510637